MySQL Forums
Forum List  »  Newbie

Database Passwords
Posted by: Ken Smith
Date: April 29, 2016 07:29AM

Hi This seems a daft question as I'm not a MySQL newbie but this is a newbie question.

I enter as follows

create database TTX_ASA;

GRANT ALL PRIVILEGES on TTX_ASA.* to 'ttx_asa'@'%' IDENTIFIED BY '*******';

flush privileges;

Where ******* is the password

when I try to access the database I get

mysql -uttx_asa -p TTX_ASA
Enter password:
ERROR 1045 (28000): Access denied for user 'ttx_asa'@'localhost' (using password: YES)

Whereas I have another database on the same server that works fine

like this

mysql -uttx_cjc -p TTX_CJC

and it works just fine

I can't believe that TTX_ASA is a special name to MySQL and somehow not usable as I have used it on another machine without problems.

I have dropped the database and re-created it. Should I backup all the databases, wipe them and start again?

This is on Centos 6

Any suggestions welcome

Thanks

Ken

Options: ReplyQuote


Subject
Written By
Posted
Database Passwords
April 29, 2016 07:29AM
April 29, 2016 08:49AM
April 29, 2016 09:17AM
April 29, 2016 09:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.