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
see allowed ip adresses
SELECT Host FROM mysql.user WHERE user='root';


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


Post a Comment

Popular posts from this blog

codefights smooth sailing ( CommonCharacterCount)

How to remove 8443 port in URL in tomcat