Post: Creating a MySQL User
Creating a MySQL User →
Posted Tuesday 20th June 2006 16:06 GMT
In Examples of good practice, or not...
Also, you should never routinely give users the grant privilege, since this is a gaping security hole, especially in a web application. In most situations, only the MySQL root user needs to have grant privileges.
The MySQL documentation has examples of creating a user other than root which includes granting the Grant option to user.
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
If GRANT option is not required the GRANT statement to create a MySQL user would be:
GRANT ALL PRIVILEGES ON test TO 'mysql'@'localhost'
IDENTIFIED BY 'mysql'
Top stories
Popular Whitepapers
- Virtualization with the Intel Xeon Processor 5500 Series
A proof of concept - A Smart Path to Virtualization
Virtualization and Flexible Computing - Systems management simplified
Guided tour: Dell Management Console - Data Center Savings
Realizing Data Center Savings with an Accelerated Server Refresh Strategy - Optimizing the data center for cost and efficiency
Control costs and add value to the business - Staying committed to server refresh reduces cost
Can a server refresh help your company?
