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: newbie: creating database error
Admin-Stress, Tuesday, November 05, 2002, 12:41:08 AM, you wrote: AS After playing around with 'test' database, then I would like to create my own database. AS I logged in into mysql using root account and created a database. AS But, when I logged in using regular user, I got his error : AS ERROR 1044: Access denied for user: '@localhost' to database 'card' AS What necessary to do to create database? AS I tried to create a database using regular user, still got same error. AS I did change create_priv='Y' in user table from mysql database for this regular user. AS Anyone know how the basic steps to create database? or any documentation/website resource would be AS appreciated. Have you executed FLUSH PRIVILEGES after editing grant tables? GRANT command is easy in use to grant rights for users: http://www.mysql.com/doc/en/GRANT.html -- 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 - 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
newbie: creating database error
After playing around with 'test' database, then I would like to create my own database. I logged in into mysql using root account and created a database. But, when I logged in using regular user, I got his error : ERROR 1044: Access denied for user: '@localhost' to database 'card' What necessary to do to create database? I tried to create a database using regular user, still got same error. I did change create_priv='Y' in user table from mysql database for this regular user. Anyone know how the basic steps to create database? or any documentation/website resource would be appreciated. Thanks. kapot __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.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: newbie: creating database error
try www.mysql.com, i heard they have docs there you can read...:) -Original Message- From: Admin-Stress [mailto:meerkapot;yahoo.com] Sent: Monday, November 04, 2002 1:41 PM To: [EMAIL PROTECTED] Subject: newbie: creating database error After playing around with 'test' database, then I would like to create my own database. I logged in into mysql using root account and created a database. But, when I logged in using regular user, I got his error : ERROR 1044: Access denied for user: '@localhost' to database 'card' What necessary to do to create database? I tried to create a database using regular user, still got same error. I did change create_priv='Y' in user table from mysql database for this regular user. Anyone know how the basic steps to create database? or any documentation/website resource would be appreciated. Thanks. kapot __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.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 - 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: newbie: creating database error
Try using shellmysqladmin -u root -p -h hostname databasetobecreated password: ~Kelly W. Black -Original Message- From: Admin-Stress [mailto:meerkapot;yahoo.com] Sent: Monday, November 04, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: newbie: creating database error After playing around with 'test' database, then I would like to create my own database. I logged in into mysql using root account and created a database. But, when I logged in using regular user, I got his error : ERROR 1044: Access denied for user: '@localhost' to database 'card' What necessary to do to create database? I tried to create a database using regular user, still got same error. I did change create_priv='Y' in user table from mysql database for this regular user. Anyone know how the basic steps to create database? or any documentation/website resource would be appreciated. Thanks. kapot __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.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 - 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
Problom with creating database
I have a brand new install of mysql . I have set every thing up just like I have on many Linux server but this one I am getting an error when I try to create a database from the Command line from and PHP script or from phpMyAdmin. Could somebody tell me what this error is and how I can fix it. I have un-installed and re installed mysql at least 3 times and I can not get it to work. 1006: Can't create database 'control'. (errno: 122) -- Best regards, rdkurth mailto:[EMAIL PROTECTED] - 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: Problom with creating database
rdkurth, Tuesday, September 17, 2002, 9:43:37 AM, you wrote: rasdn I have a brand new install of mysql . I have set every thing up just rasdn like I have on many Linux server but this one I am getting an error rasdn when I try to create a database from the Command line from and PHP rasdn script or from phpMyAdmin. Could somebody tell me what this error rasdn is and how I can fix it. I have un-installed and re installed mysql at rasdn least 3 times and I can not get it to work. rasdn 1006: Can't create database 'control'. (errno: 122) $ perror 122 Error code 122: Disk quota exceeded -- 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 - 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: creating database
sql,query How can i have each users database to be stored in it's home dir ? - 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
creating database
As i selling web hosting with mysql as a package, and i like to restrict on the amount of space used. I had setup quotas on the plans. How can i create databases to the user's account, home dir, so that the customer can check his quota. Or how should i go about restricting? sql,query - 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: creating database
Setup a user level my.cnf file and make sure the data dir isn't overriden by the other levels of my.cnf Just a theory, I haven't tested it ! -Original Message- From: Info [mailto:[EMAIL PROTECTED]] Sent: 11 July 2002 15:17 To: [EMAIL PROTECTED] Subject: Re: creating database sql,query How can i have each users database to be stored in it's home dir ? - 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
Re: creating database
This is not possible. Info wrote: sql,query How can i have each users database to be stored in it's home dir ? - 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 -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - 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: creating database
Sure it is. It's just TRICKY. :) step 1. Create database. step 2. Move database to users' homedir step 3. Symlink $USERHOME/databasedir/ to $MYSQLDATADIR Alexander Barkov wrote: This is not possible. Info wrote: sql,query How can i have each users database to be stored in it's home dir ? - 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 -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 Faster, Better, Cheaper: Pick any two. - 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: creating database
Yes, it is possible unless you insist on using an unimaginative, strict, interpretation of what Info wrote. Mechanism 1: Create a separate database server for each database. You can create servers wherever you want. Mechanism 2, which might not work, but might be worth a try: assuming a single server with multiple databases; after creating the database, move its directory to the desired location and then create a symlink from the new location to the old location. Cs Alexander Barkov wrote: This is not possible. Info wrote: sql,query How can i have each users database to be stored in it's home dir ? - 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
creating database
Hi there, I'm having a hard time creating a databae... My db name is pool and my mySql username is contact. This is what I did... GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? - 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: creating database
Hi Look at the sample database. try this create.sql== # Change user and password to add privileges for different user. # Note that user with no hostname given is equivalent to specifying # % as the hostname. GRANT ALL ON pool.* TO contact; DROP DATABASE IF EXISTS contact; CREATE DATABASE aardwolf; === use something like the line below should do the trick :-) mysql -u root create.sql Also make sure you have deleted the anonymous users in the user data base they cause alsorts of problems Richard - Original Message - From: Jeremy Morano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 25 September 2001 16:38 Subject: creating database Hi there, I'm having a hard time creating a databae... My db name is pool and my mySql username is contact. This is what I did... GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? - 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
Re: creating database
Jeremy Morano writes: GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? A user can of course not grant himself access to things. You need to do those things as a user with global CREATE and GRANT privileges. Read the manual on how GRANT works and things may become a little clearer (although that part of the manual _does_ need more information. But _I_ ain't gonna write it. Not today, anyway.) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
[MySQL] Error when creating database
I created a script to create a table. The script is as follows: === use Contacts; CREATE TABLE Lead (lastname varchar(50), firstname varchar(50), title varchar(200), company varchar(200), telephone_work varchar(15), telephone_home varchar(15), fax varchar(15), email varchar(100), address varchar(255), city varchar(100), state varchar(100), postal_code varchar(10), country varchar(100), note varchar(255)); when I run the following command: /usr/local/mysql/bin/mysql cr_Lead.sql I got the following error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) = what could be the problem? thanks YekSoon __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.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
creating database with permissions
Hai, i want to create database in mysql with user permission,pls. help me out. Regards sakthi. - 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
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
Creating database
Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards, Herman Pool Nibble Consultancy b.v. Oude Amersfoortseweg 22 1213 AD Hilversum The Netherlands tel: +31 (0)35 6217619 fax:: +31 (0)35 6219819 www.nibble.nl
Re: Creating database
On Fri, 30 Mar 2001, Herman Pool wrote: Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? You don't have the privileges to perform a CREATE command. This is part of the MySQL authorization mechanism. From the error message I see that you are connected as user 'nobody', who most probably doesn't have such a privilege. Try connecting as the DB admin (if you have that authority). If not do a: select user(); to see the username you are logged in under and then: select * from mysql.user; and check that the Create_priv column is set to 'Y' for this user. If this is 'N' you'll have to check the mysql.db table and maybe even the mysql.host table. To understand what's going on start reading at: http://www.mysql.com/doc/P/r/Privileges.html regards, thalis - 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: Creating database
Am 17:44 30.03.2001 schrieb Herman Pool: Hi out there, I'm new with MySQL. I have installed Linux 6.0 and MySQL 3.23.33 This happens when I want to create a database: [mysql@nestorix mysql]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 49 to server version: 3.23.33 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create database java_db; ERROR 1044: Access denied for user: '@localhost' to database 'java_db' mysql \q Bye [mysql@nestorix mysql]$ Why? What did I do wrong? Any ideas? with kind regards, Herman Pool Nibble Consultancy b.v. Oude Amersfoortseweg 22 1213 AD Hilversum The Netherlands tel: +31 (0)35 6217619 fax:: +31 (0)35 6219819 www.nibble.nl have you tried mysql -u root? Normally only user root has all privileges Create others with GRANT, check manual Check http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/G/R/GRANT.html Hope it helps regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - 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
