Re: MySQL Error 1044: an explanation
Hi all,
This problem has to do with privileges. When you connect via your client (command line or graphic) you connect to the mysql server as a specific user. This user has some privileges on the server, the databases on the server, the tables of a database, and the columns of a table.
These privileges assure that each user will be able to do whatever actions he is allowed to do.
So when you get this error it means that the user you are trying to log in with doesn't have the right to create databases, or that he has not the right to use that database etc.
You can do 2 things:
1) connect as root and grant your user the privileges you want
2) if you re just trying out how mysql works, at home (no security is needed) use the root account.
For more info check mysql manual, 5.6. The MySQL Access Privilege System, to understand how things work and then 13.5.1.3. GRANT and REVOKE Syntax
Subject
Written By
Posted
February 27, 2005 05:19AM
September 12, 2005 07:48AM
Re: MySQL Error 1044: an explanation
September 12, 2005 11:39AM
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.