MySQL privileges granting
Posted: Fri Nov 18, 2011 7:07 pm
In order to make it work between CGI and MySQL, privilege granting from command line is needed.
1. Log in to MySQL as root or admin user
2. Grant privileges to user(s)
3. Show grant privileges
Then, CGI is able to communicate with database schema and table.
1. Log in to MySQL as root or admin user
2. Grant privileges to user(s)
Code: Select all
mysql> GRANT ALL PRIVILEGES ON Gemini_Twins.* TO 'gtdba'@'%' IDENTIFIED BY PASSWORD '*981197945B47C87724B0FDB0CCBA03BF38FB9232' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)
Code: Select all
mysql> show grants for gtdba;
+------------------------------------------------------------------------------+
| Grants fortdba@% |
+------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON `Gemini_Twins`.* TO 'gtdba'@'%' WITH GRANT OPTION |
+------------------------------------------------------------------------------+