MySQL Forums
Forum List  »  MySQL Administrator

How to start mysql using my own user account rather than root?
Posted by: Pei JIA
Date: April 01, 2011 06:24PM

1) "mysql -u root -p" works fine
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


2) "mysql" fails
$ mysql
ERROR 1045 (28000): Access denied for user 'jiapei'@'localhost' (using password: NO)


How can I start mysql just using my own user account?


Rgds
JIA

Options: ReplyQuote


Subject
Written By
Posted
How to start mysql using my own user account rather than root?
April 01, 2011 06:24PM


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.