MySQL - Create user/database

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

MySQL - Create user/database

Post by mikeb » Sat Nov 11, 2006 11:35 am

[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!
Mike Benoit

Locked