I executed c:\mysql\bin\mysql.exe
and then I typed in: create database learnsql;
and this is what appeared: ERROR 1044: Access denied for user: '@localhost' to
database 'learnsql'
Please help me with this problem
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
At 12:45 21/7/2003 -0400, Rosanne Park - Undergraduate Student wrote:
Hi,
>I executed c:\mysql\bin\mysql.exe
>
>and then I typed in: create database learnsql;
If you are with the default install, do:
mysql -uroot
this permits you to create database, however your next step
is to learn the GRANT/REVOKE commands for to set the user's
privileges. Read the Manual at \docs directory.
--=20
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org
Rosanne Park - Undergraduate Student writes:
> I executed c:\mysql\bin\mysql.exe
>
> and then I typed in: create database learnsql;
>
> and this is what appeared: ERROR 1044: Access denied for user: '@localhost' to
> database 'learnsql'
>
> Please help me with this problem
>
>
This is not a bug.
You should have passed -u .... option, where .... is a defined user
name for your MySQL server.
Without it, you have logged in as anonymous user, with very restricted
rights.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
--0-1156872922-1058973127=:59154
Content-Type: text/plain; charset=us-ascii
When you install MySQL, there is a default user account with a blank name. This user does not have the necessary rights to create a database.
try logging in executing: c:\mysql\bin\mysql.exe -u root
The root user has the necessary rights
Rosanne Park - Undergraduate Student
I executed c:\mysql\bin\mysql.exe
and then I typed in: create database learnsql;
and this is what appeared: ERROR 1044: Access denied for user: '@localhost' to
database 'learnsql'
Please help me with this problem
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=adrieb10@yahoo.com
---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
--0-1156872922-1058973127=:59154--
Darian Johnson writes:
> When you install MySQL, there is a default user account with a blank name. This user does not have the necessary rights to create a database.
>
> try logging in executing: c:\mysql\bin\mysql.exe -u root
>
> The root user has the necessary rights
>
> Rosanne Park - Undergraduate Student
> I executed c:\mysql\bin\mysql.exe
>
> and then I typed in: create database learnsql;
>
> and this is what appeared: ERROR 1044: Access denied for user: '@localhost' to
> database 'learnsql'
>
> Please help me with this problem
>
HI!
On Windows, when properly installed user root has all privileges.
But to login as user root you always have to type :
mysql.exe -u root
In the first command you have passed the argument correctly, but in
the second you did not.
User with empty user name is anonymous user with very limited
privileges.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org