LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 12-26-2003, 10:31 AM   #1
huno
Member
 
Registered: May 2002
Distribution: Slackware 9.1
Posts: 161

Rep: Reputation: 30
mysql user


hi people ..

how to create mysql root user to setup phpmyadmin ..

i'm tried to use this command

mysql --user=root --password=mypassword

it said

Error 1045 : Access denied for user: 'root@localhost' (Using password: YES)

how can i create user to setup phpmyadmin ..

i'm using Fedora core 1

thanx
 
Old 12-26-2003, 11:34 AM   #2
sonar0m
LQ Newbie
 
Registered: Dec 2003
Location: Austin, TX
Posts: 5

Rep: Reputation: 0
well i had something similar happen. when i first set up my sql i had nothing but root ((when logged in under root)) could create or do anything with tables. their is a default access table when setting up. that only root can do anything with sql. i don't remember what the table is but i found it on one of the many "how to" pages. one such how to is about PHP how to .. .i skimmed it and it might help .. but if you are having access usage issues you will need to go to the systems table((don't know the name)) and alter it

sorry i could not help any more than that
 
Old 12-26-2003, 02:09 PM   #3
Looking_Lost
Senior Member
 
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
mysqladmin --user=root password mypassword

should set a password for root, assuming mysqladmin is in your path.

If this is a clean mysql install you should be able to log into it just doing

mysql

or

mysql -u root

If it is don't forget to delete the "blank user"
 
Old 12-26-2003, 03:21 PM   #4
tokkee
Member
 
Registered: Dec 2003
Distribution: Debian, OpenBSD
Posts: 46

Rep: Reputation: 15
Quote:
Originally posted by Looking_Lost
[B]If this is a clean mysql install you should be able to log into it just doing

mysql

or

mysql -u root/B]
... before setting a password for root

if you did set a password for root using e.g. the command suggested by Looking_Lost you need 'mysql -p' or 'mysql -u root -p' to login (this will prompt for the password). when logged in as root you can set up permissions for any other user using mysql's 'grant' command (see the documentation for details)
 
  


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 error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
mysql user, help! chidomen Programming 2 01-14-2005 10:17 AM
mysql cannot create a user nocturnal Linux - Software 1 07-05-2003 10:52 AM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 02:24 AM
Changing Mysql user? Ricardo77uk Programming 13 06-30-2001 05:48 PM


All times are GMT -5. The time now is 07:47 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