Helpful Information
 
 
Category: MySQL
Setting database user and password

I have set up mysql with phpmyadmin on my localhost. I created a database using phpmyadmin. Now i want to create a user and password for the database. Can I use phpmyadmin to do this? Or do I need something else? How do I go about doing it? I went into the mysql user table and tried setting the 'host' , 'user' and 'password' fields, but no luck.

G

You have to use the GRANT (http://www.mysql.com/doc/G/R/GRANT.html) command.

Thanks, Benahimvp, this is what I used, and it worked:

GRANT ALL PRIVILEGES ON db.* TO [email protected] IDENTIFIED BY 'passw'

G

:D










privacy (GDPR)