Fernando <[EMAIL PROTECTED]> wrote: > Hello, > i've just installed the 3.23.57 version in my account and i don't have root > privileges. The problem is the if i try to create a database, like this > > mysql> create database example; > > i get the following message: > > "Error 1045: Access denied for user : '@localhost'. > > Is this because i'm not the root?
Because you doesn't have rights to create a database. The above error means that you are connected as anonymous use. By default anonymous user has permissions only on the database 'test'. > If i try to use a database (one it doesn't exist) like this > > mysql> use my_database; > > i get the following line > > "Error 1044: Access denied for user : '@localhost' to database my_database". > > I know that it should give me an error because the database doesn't exist, but why > this "access denied" message? Because you doesn't have permissions :) If you had appropriate privileges you should get "Unknown database" error. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
