MySQL Forums
Forum List  »  Install & Repo

Re: MySQL Error 1044: an explanation
Posted by: Vangelis Katsikaros
Date: September 12, 2005 11:39AM

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

Options: ReplyQuote


Subject
Written By
Posted
February 27, 2005 05:19AM
March 20, 2005 05:52AM
March 20, 2005 05:53AM
March 20, 2005 05:49PM
March 22, 2005 10:56AM
July 03, 2007 03:48AM
April 05, 2005 05:00AM
May 26, 2005 10:56AM
May 03, 2008 11:20PM
July 06, 2008 05:48AM
March 20, 2005 06:09PM
July 11, 2005 03:40AM
July 11, 2005 11:52AM
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.