LinuxQuestions.org
Review your favorite Linux distribution.
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 07-05-2003, 09:58 AM   #1
nocturnal
Member
 
Registered: Apr 2003
Location: Sweden
Distribution: Slackware, LFS
Posts: 80

Rep: Reputation: 15
Unhappy mysql cannot create a user


i've been around irc two times for this and read the tutorial on mysql.com but i still can't find a solution to this...

i got everything working right on my slackware 9 box with apache, php and sql so i installed phpmyadmin and i accidently deleted all the users in phpmyadmin and now i can't access anything in mysql so i tried using the stuff in the mysql.com tutorial to create a user and i get this error:
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
when trying to do this:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
-> IDENTIFIED BY 'the_password_i_want_to_set' WITH GRANT OPTION;
i'm begging people to help me now because i'm on the edge here and i've been trying to solve this for 3 days with no answers from either #mysql on freenode or #linuxhelp on undernet
 
Old 07-05-2003, 11:52 AM   #2
Drogo
Member
 
Registered: Oct 2002
Distribution: RedHat 8 or 9 (shrike)- Fedora Core 1,2
Posts: 215

Rep: Reputation: 30
try this

1)create the db first (mybuddy)

2)Enter the command exactly as show below this will create a user called buddy_user with password mypass on the mybuddy database.

GRANT ALL PRIVILEGES ON mybuddy TO buddy_user@localhost IDENTIFIED BY 'mypass' with GRANT OPTION;





hope it helps

Last edited by Drogo; 07-05-2003 at 12:35 PM.
 
  


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
user home dir doesn't create when new user add dev_mohamed Linux - Software 3 01-12-2007 02:08 AM
Auto create user, mysql and ftp haze Linux - General 1 04-12-2005 11:10 AM
Mysql how to create user? fturcic Linux - Software 1 02-01-2005 12:23 AM
MySQL - command - create user/single database dmedici Linux - Software 3 06-21-2004 04:17 PM
how to create a user that has access priv to mysql in rh 9.0? spyghost Linux - Software 4 11-02-2003 04:15 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:08 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration