MySQL - Create user/database

Frequently Asked Questions
Locked
mikeb
Posts: 709
Joined: Thu Jul 27, 2006 11:58 am

MySQL - Create user/database

Post by mikeb »

[root@timetrex ~]# mysql -u root mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO 'timetrex'@'localhost' IDENTIFIED BY '<MY_PASS>' WITH GRANT OPTION;

mysql> create database timetrex;

mysql> quit;

Now to test that everything worked:

[root@timetrex ~]# mysql -u timetrex -p<MY_PASS> timetrex

It you get the "mysql>" prompt, it worked!
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Locked