LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Ubuntu (https://www.linuxquestions.org/questions/ubuntu-63/)
-   -   Help in getting my account some mysql priveledges (https://www.linuxquestions.org/questions/ubuntu-63/help-in-getting-my-account-some-mysql-priveledges-363757/)

mobo 09-15-2005 06:55 PM

Help in getting my account some mysql priveledges
 
I am trying to get my hands dirty on ubuntu for a few weeks now in the hopes of running it as a server shortly. I have the system up and running and would like to have some assistance in getting my user account somemysql priveledges. I have tried several things but nothing...

rjlee 09-17-2005 06:20 AM

Do you mean that you want your user to be able to log in to a mysql database?

Mysql uses a seperate set of user accounts to the Linux login. By default, the mysql command-line tool will use the Linux username as the Mysql username (the -u option overrides this). So you need to make sure you have created a mysql account for the user.

Instructions on adding users here:
http://dev.mysql.com/doc/mysql/en/adding-users.html

The mysqladmin tool will also help you. For details of that, type this at the BASH prompt (outside of mysql):
Code:

man mysqladmin


All times are GMT -5. The time now is 02:22 AM.