LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices

Reply
 
Search this Thread
Old 09-15-2005, 06:55 PM   #1
mobo
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
rjlee
Senior Member
 
Registered: Jul 2004
Distribution: Ubuntu 7.04
Posts: 1,990

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


Reply


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 09:34 PM.

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