Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Ubuntu This forum is for the discussion of Ubuntu Linux.


  Search this Thread
Old 09-15-2005, 06:55 PM   #1
LQ Newbie
Registered: Mar 2004
Location: Cape Breton
Posts: 29

Rep: Reputation: 15
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...
Old 09-17-2005, 06:20 AM   #2
Senior Member
Registered: Jul 2004
Distribution: Ubuntu 7.04
Posts: 1,990

Rep: Reputation: 68
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:

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql - Howto insert 'admin' account into table ??? b:z Linux - General 6 03-29-2005 03:44 AM
MySQl account login, PHP agallant Programming 2 07-16-2004 11:01 AM
MySQL deleted root account and can't re-install... ivj Linux - Software 2 07-09-2004 10:51 PM
Fixing MySQL root account permissions. TexasDex Linux - Software 2 02-02-2004 09:39 PM
Root priveledges? BajaNick Linux - General 2 07-30-2003 12:06 AM

All times are GMT -5. The time now is 10:48 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration