Ubuntu Notes and How-Tos

Sunday, October 23, 2005

MySQL



This is right after MySQL is installed.

1. Assign password to "root" account:
$ mysqladmin -u root password "somepassword"

2. Enable networking by commenting out the skip-networking entry in /etc/mysql/my.cnf

3. Create account with admin privileges that can connect from wherever:
$ mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'

-> IDENTIFIED BY 'somepassword' WITH GRANT OPTION;

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home