Hey,
I'm trying to add a user to a mySQL database and this is what I have so far:
User Host Password Global privileges Grant
atlanta % Yes SELECT No
When I try to log onto it from the server its running on its saying:
~]# mysql -u atlanta -p
Enter password:
ERROR 1045: Access denied for user: 'atlanta@localhost' (Using password: YES)
I have no idea what i'm doing wrong... Can someone help me?
Add user to mysql database issues!!!
Moderator: General Moderators
Are you setting up the user via the command line or with phpmyadmin?
If the command line, what happens when you run this query from the `mysql` database:
Your password should be encrypted using MySQL's password() command, so if the password is in plain text - there's your problem.
Also, if you use the
If the command line, what happens when you run this query from the `mysql` database:
Code: Select all
SELECT
*
FROM
user
WHERE
user = 'atlanta'Also, if you use the
Code: Select all
[/code ] tags around command line stuff (such as database query results), it spaces things much nicer.Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
I used phpMyAdmin to create the user.
I have reloaded the privlieges with phpMyAdmin
I have reloaded the privlieges with phpMyAdmin
Code: Select all
FLUSH PRIVILEGES;
Last edited by kingdbag on Wed May 23, 2007 6:16 pm, edited 3 times in total.