linux poison RSS
linux poison Email

Howto create a MySQL user

Here is a quick tip how to create from mysql new database and a new mysql user that has full privileges on this newly created database:

mysql -uroot -p


CREATE DATABASE ;
GRANT ALL PRIVILEGES ON .* TO 'my_user'@'localhost' IDENTIFIED BY 'my_password' WITH GRANT OPTION;


0 comments:

Post a Comment

Related Posts with Thumbnails