1
Using the MySQL database with GNU Enterprise
2
============================================
5
Setting up the permissions on the database server
6
-------------------------------------------------
8
Enter the mysql database using the 'mysql' tool and create a privileged account
11
GRANT ALL PRIVILEGES ON *.* TO '<user>'@'%' IDENTIFIED BY '<pwd>';
12
GRANT ALL PRIVILEGES ON *.* TO '<user>'@'localhost' IDENTIFIED BY '<pwd>';
14
(replace <user> with your username and <pwd> with your database password)
15
(the second grant will be needed for local access)
17
To automate access control, you can add a file "~/.my.cnf" with the following
28
(replace <user> with your username and <pwd> with your database password)
29
Please make sure this file has mode 0600 :)