Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 12-26-2003, 11:31 AM   #1
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

Old 12-26-2003, 12:34 PM   #2
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, 03:09 PM   #3
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 -u root

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

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



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)


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 09:44 AM
mysql user, help! chidomen Programming 2 01-14-2005 11:17 AM
mysql cannot create a user nocturnal Linux - Software 1 07-05-2003 11:52 AM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 03:24 AM
Changing Mysql user? Ricardo77uk Programming 13 06-30-2001 06:48 PM

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