Wednesday, December 19, 2012

Mysql make user and password

First of all make database
mysql> create database DBName;

See all database list
mysql> show databases

mysql> use mysql

Making general user
mysql> grant usage on *.* to amarokuser@localhost identified by 'amarokpasswd'; Query OK, 0 rows affected (0.00 sec)
Making the user having all authorities
mysql> grant all privileges on amarokdb.* to amarokuser@localhost ; Query OK, 0 rows affected (0.00 sec)
commit all changes
mysql> FLUSH PRIVILEGES;
see allowed ip adresses
SELECT Host FROM mysql.user WHERE user='root';

1 comment:

  1. Thanks for your grateful informations, am working in FNT software solutions, so it will be helpful info for my works.

    ReplyDelete