Hi, I know this has probably bee

[tviman]

Hi,

I know this has probably been answered a hundred times but please bear with me...

I new to Mysql and I'm wanting to set up online tables for my web site. Is there a default password to access the tables or do I have to set up a user/password table before I can to read/write to the tables.

I've read 2 or 3 'how-to's' on the subject but I'm still not certain how this works.


Thanks for your patience...

There's always a better way...

 

[danielhozac]

The default user is root, with a blank password.
Though, in my opinion, you shouldn't use the root use for web applications. You should create a new user that only has the privileges you need. To create a user, log into MySQL as root and type

GRANT SELECT, INSERT, DELETE ON *.* TO username IDENTIFIED BY 'password';

Change the SELECT, INSERT, DELETE to whatever privileges your web applications need. If your applications only use one database, change *.* to databasename.*. //Daniel