MySQL Forums
Forum List  »  MySQL Administrator

Re: How to start mysql using my own user account rather than root?
Posted by: Ronan Cashell
Date: April 22, 2011 05:52PM

Login to mysql using the root user then

mysql> create user 'jiapei'@'localhost';

make sure you also grant access to the databases that you want this person to be able to access

mysql> grant all on <db>.* to 'jiapei'@'localhost';

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Written By
Posted
Re: How to start mysql using my own user account rather than root?
April 22, 2011 05:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.