Re: Error creating database
Marty,
I've copied the list on this reply. I hope you don't mind. It's a good
idea to keep the discussion on the list. There are a lot of experts
there, so the speed and quality of your answers is improved when you
send to the list rather than to an individual. Plus, others may benefit
from your question and its answers.
I think you've asked beginner questions, not stupid questions. It takes
some getting used to at first, but mysql users are separate from Mac
users. Think of them as separate systems, even though one runs on the
other. When you ran mysql_install_db, you got 4 mysql users,
[EMAIL PROTECTED], [EMAIL PROTECTED], ''@localhost, and ''@hostname, where
hostname is the name of your Mac. The mysql root user is the admin,
the anonymous user ('') can't do much. If you don't specify a mysql
username to the client, mysql tries to use your Mac username, but it has
to exist in the user table. So, if you simply enter `mysql` at the
command line, you are trying to log into mysql as [EMAIL PROTECTED],
but since that user doesn't exist in the mysql user table yet, you wind
up as the anonymous user.
The fix is to log into mysql as root (or use mysqladmin) and create the
[EMAIL PROTECTED] user and give yourself appropriate privileges. A
prudent course might be to leave database creation to root, and give
yourself all privilieges on your dbs. Assuming you've followed the
instructions to set a password for [EMAIL PROTECTED], you could do the
following:
in the terminal, start the mysql client:
mysql -u root -p #you'll be prompted for the password
in the mysql client:
mysql CREATE DATABASE dogs; #root creates the db
mysql GRANT ALL ON dogs.* to [EMAIL PROTECTED]
- IDENTIFIED BY 'your_mysql_password';
That last command does 3 things
1) Creates the mysql user [EMAIL PROTECTED], if it doesn't already exist.
2) Sets [EMAIL PROTECTED]'s password to the string after IDENTIFIED BY.
3) Gives [EMAIL PROTECTED] all rights to the dogs database.
After that, you should be able to enter `mysql -p` to log into mysql as
martyray.
I recommend the online manual together with just trying things out.
Here are a couple relevant pages to start:
http://www.mysql.com/doc/en/Privileges.html
http://www.mysql.com/doc/en/GRANT.html
Michael
Marty Ray wrote:
Thanks a lot Michael! That explains some of the wording in the error
messages '@localhost'. I have a ready stupid question though. How did I
get logged in as anonymous? I thought I was logged in as
[EMAIL PROTECTED] Doesn't that happen when I log onto my Mac? Surely I
don't have to log in as root all the time?
Thanks again...
Marty
On Feb 7, 2004, at 10:20 PM, Michael Stassen wrote:
mysql wrote:
HI everyone:
I am using a dual 800 MHz power mac G4 in which I have installed
MySQL. When ever I try to create a new database in MySQL, I receive
the following error
mysql create database dogs;
ERROR 1044 (42000): Access denied for user: ''@'localhost' to
database 'dogs'
You are logged in as the anonymous (no username) user ''@'localhost'.
The anonymous user doesn't have privilieges to do much (nor should
he). In fact, many people delete the anonymous user.
Can anyone assist me in how to fix this error? Thanks.
Mark
Once you've followed the directions to set a password for the root
user, log in as root to create databases.
mysql -u root -p
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error creating database
HI everyone: I am using a dual 800 MHz power mac G4 in which I have installed MySQL. When ever I try to create a new database in MySQL, I receive the following error mysql create database dogs; ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'dogs' Can anyone assist me in how to fix this error? Thanks. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error creating database
Make sure that you have persmission to create database. Check MySQL manual: http://www.mysql.com/doc/en/index.html From: mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Sat, 7 Feb 2004 19:00:54 -0500 HI everyone: I am using a dual 800 MHz power mac G4 in which I have installed MySQL. When ever I try to create a new database in MySQL, I receive the following error mysql create database dogs; ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'dogs' Can anyone assist me in how to fix this error? Thanks. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Let the advanced features services of MSN Internet Software maximize your online time. http://click.atdmt.com/AVE/go/onm00200363ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error creating database
mysql wrote: HI everyone: I am using a dual 800 MHz power mac G4 in which I have installed MySQL. When ever I try to create a new database in MySQL, I receive the following error mysql create database dogs; ERROR 1044 (42000): Access denied for user: ''@'localhost' to database 'dogs' You are logged in as the anonymous (no username) user ''@'localhost'. The anonymous user doesn't have privilieges to do much (nor should he). In fact, many people delete the anonymous user. Can anyone assist me in how to fix this error? Thanks. Mark Once you've followed the directions to set a password for the root user, log in as root to create databases. mysql -u root -p Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error creating database
Hi, I was received a error when I was trying to create a new database on freebsd 5.1, mysql 4.0.14. The test database is working well. COMMAND: mysqladmin create desenv or mysql create database desenv; ERROR: mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'desenv'' The directory /usr/local/mysql and subfiles owner and group are mysql Anybody can help me! Thanks! Paulo Fonseca Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error creating database
Paulo Fonseca Jr. [EMAIL PROTECTED] wrote: I was received a error when I was trying to create a new database on freebsd 5.1, mysql 4.0.14. The test database is working well. COMMAND: mysqladmin create desenv or mysql create database desenv; ERROR: mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'desenv'' The directory /usr/local/mysql and subfiles owner and group are mysql Anybody can help me! Anonymous user doesn't have premissions to create database. Connect as a root or any other user that have global CREATE privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: error creating database
lol mysqladmin -u root -p create database desenv ?? Hi, I was received a error when I was trying to create a new database on freebsd 5.1, mysql 4.0.14. The test database is working well. COMMAND: mysqladmin create desenv or mysql create database desenv; ERROR: mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'desenv'' The directory /usr/local/mysql and subfiles owner and group are mysql Anybody can help me! Thanks! Paulo Fonseca Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error creating database
I get the following error when trying to create a database. Being a total newbie to MySQL I would appreciate any help I can get! --- [EMAIL PROTECTED] bobo]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 129 to server version: 3.23.56 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE bobo; ERROR 1044: Access denied for user: '@localhost' to database 'bobo' mysql --- Edward C. Dulaney Chief Engineer Crawford Broadcasting Company Colorado Region (303) 433-5500 (Office) (303) 801-0439 (Direct)
RE: Error creating database
Hi when you log in to MySQL use mysql -u root you will then be asked to enter a password. On a new instalation the password may be blank - nothing After that you should be able to create databases. You might find information about privilages and GRANT usefull http://www.mysql.com/doc/en/User_Account_Management.html HTH Peter -Original Message- From: Ed Dulaney [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 23:50 To: Mysql Subject: Error creating database I get the following error when trying to create a database. Being a total newbie to MySQL I would appreciate any help I can get! --- [EMAIL PROTECTED] bobo]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 129 to server version: 3.23.56 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE bobo; ERROR 1044: Access denied for user: '@localhost' to database 'bobo' mysql --- Edward C. Dulaney Chief Engineer Crawford Broadcasting Company Colorado Region (303) 433-5500 (Office) (303) 801-0439 (Direct) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error creating database
dont you mean: create database gnudip2; create table table1 (id int(10),some_colum varchar(255)); - Original Message - From: [EMAIL PROTECTED] To: Ana Elisa Martinez [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 10:57 PM Subject: Re: Error creating database I also get somthing like that, much mor productive to do somthing like create database gnudip2(id int(10),some_colum varchar(255)); Trying to show that you add columns with the same command. Darrell On Tue, 15 May 2001, Ana Elisa Martinez wrote: When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error creating database
When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez
Re: Error creating database
try: mysqlCREATE DATABASE gnudip2; From: Ana Elisa Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Tue, 15 May 2001 16:09:09 -0400 When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error creating database
create database gnudip2; make sure you have the right permissions as well! - Original Message - From: Ana Elisa Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:09 PM Subject: Error creating database When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error creating database
I also get somthing like that, much mor productive to do somthing like create database gnudip2(id int(10),some_colum varchar(255)); Trying to show that you add columns with the same command. Darrell On Tue, 15 May 2001, Ana Elisa Martinez wrote: When i try to create a database with the command : mysql create gnudip2; Told me an error : ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1 Why this error ??, What is wrong ?? Thanks Ana Elisa Martinez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
