Re: Newbie question
Why are you getting this message, Access denied for user '@localhost' for
database test2?
If you are logged on as 'emil' and you attempt to connect, if you are
denied access you should receive a message like this; Access denied for
user 'emil@localhost' for database test2
It would appear that you are not passing a user name to MySQL when you are
trying to connect.
If I were you, I would delete all users with either a null/blank user name
or null/blank password from my user table.
Then, I would flush priveleges.
Then, I would try to connect as the user 'emil' (-u emil).
These documents (links shown below) provide an OUTSTANDING explanation of
users and privileges for MySQL.
http://www.mysql.com/doc/C/o/Connection_access.html
http://www.mysql.com/doc/R/e/Request_access.html
http://www.mysql.com/doc/A/c/Access_denied.html
I also highly recommend the book MySQL by Paul DuBois. It has been
indispensable for me.
Respectfully,
Charles Q.
At 05:44 AM 6/21/2002, you wrote:
if i could add to this question a bit:
what are the steps in adding a user that will have access to only one
database?
i've tried using both:
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON uview.* TO user@%
IDENTIFIED BY password; (then did a FLUSH PRIVILEGES)
and i've tried adding directly yo the users database:
NSERT INTO user
VALUES('localhost','USERNAME',PASSWORD('some_pass'),'SELECT','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
but i can't seem to get things to work. i've looked over the manual and a
small tutorial.
are there some steps i'm missing?
thanks.
jason upton
6/20/2002 4:30:47 PM, Emma Grant [EMAIL PROTECTED] wrote:
Hi, I am just starting out with mysql.
MySQL allows anon access so I don't have to log on to the sql just the
linu server.
I am trying to create a test database 'test2'. I am logged on as my user
'emil' (not root) on a test linux server. When I go to create the
database:
mySQL CREATE DATABASE test2;
It gives me the following error.
Error: 1044: Access denied for user '@localhost' for database test2
I then log in as root and change my privelages:
mySQL GRANT ALL ON test2.* for emil;
But still I get the same error when I try to create it.
In fact, I can't get on to a database even if the root creates it and
then I GRANT the user 'emil' ALL to the newly created database.
Can someone direct me in the right place?
Thanks,
Emma
-
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
-
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: Problems starting MySQL as a Service for all users
Kirk, I am somewhat confused by your question. I must misunderstand what it is that you are trying to ask, because what it appears that you are asking makes no sense. Once MySQL was installed as a service, why does it matter which account starts it? Are you not the admin on the box? Are you trying to start multiple instances of the MySQL service? Logging off of the admin account will not stop a service on a Windows 2000 box. Even though you log off the admin account, MySQL should still be running. Or, when you say started do you mean connect to the running server? What is the output of the following command on the server running MySQL? netstat -a -p tcp Respectfully, Charles Q. At 08:23 PM 6/5/2002 -0500, you wrote: I've installed MySQL as a service using mysqld-nt --install on W2K. No problem there, says service successfully installed. BUT, when I try to log off the admin account and on to the regular power user account MySQL will not start automagically and cannot be started manually. Pop back over to the admin account and MySQL acts like nothing was ever wrong. Is this an issue that can be overcome by manually installing MySQL as a service instead of using the above? And how do you accomplish that? If you know or have heard of this before please help me out; I'd really like to have MySQL running for all users (that would enable the Apache-based site I'm running on the same box to access the database at all times). Thanks! Kirk - 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: Thanks
You are very welcome. I am glad I was able to help. Charles Q. At 03:58 PM 6/6/2002 -0500, k wrote: Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block connections to MySQL (since before I uninstalled, on normal [non-admin] user accounts, I could not connect to the db - attention Chris - and the stopped service could not be started from the console - even though it showed up as listening on the correct port no connection could be made). Now I can connect to the db on all user accounts. I don't really know why this happened or how, but thanks for walking me through it. I appreciate all the help from everybody. cheers, Kirk - 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: how do I get off this list?
Have you tried the link at the bottom of every message from the list? Chuck At 10:22 AM 6/5/2002 -0700, Bob Purvy wrote: I'm really sorry to send this to the whole list, but I've tried every conceivable thing I can think of, over the last week, and none of it works. I promise this will be my only broadcast message, regardless of what happens next (so you don't need to flame about it!) specifically, I've tried: [EMAIL PROTECTED] (at least three times) [EMAIL PROTECTED] [EMAIL PROTECTED] and the the List-Unsubscribe header: [EMAIL PROTECTED] and several other addresses, . All ineffective. for the last one, I got back this: = Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. This is a generic help message. The message I received wasn't sent to any of my command addresses. --- Administrative commands for the mysql-digest list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [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 - 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: Question
I hope what I am going to say does not appear short or rude. It is not meant to be. Having said that - Why do you think MySQL doesn't support transactions? Have you read the documentation? You really should read all of the available documentation before posting a question like that. You have misconceptions that the current publicly available documentation would clear up. MySQL (via an external db) does support transactions. Charles Q. At 03:23 PM 3/19/2002 +0530, you wrote: To Dear Sirs 19/03/02 I am pankaj from Bombay India I have downloaded Version mysql -3.23.49,my question is why dosent mysql support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc From Pankaj - 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: error starting mysql
My last email was technically correct, but not the root of your problem. Please accept my humble apologies. The answer to your problem is in the MySQL book by Paul DuBois, on page 429. If you do not have the book (and I highly recommend it), I will summarize. This situation happens if your grant tables contain the default entries installed by the mysql_install_db initialization script. It is caused by having anonymous users in your user table in the mysql database. And, it only manifests itself when you are attempting to connect via the localhost. To correct this problem, do this: % mysql -u root mysql mysql DELETE FROM user where User=; mysql FLUSH PRIVILEGES; If you have assigned a password to the root user (as I have done), you will have to do this: % mysql -u root -p mysql mysql DELETE FROM user where User=; mysql FLUSH PRIVILEGES; Again, sorry about my last email. Sincerely, Charles Quesenberry At 02:13 PM 3/7/2002 -0800, you wrote: Hi, I assigned rights to a user in mysql, mysql grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error message, ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES) Would someone please help me how to troubleshoot this? Thanks, Norman - 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: hosting
At 12:53 AM 3/8/2002 +0100, you wrote: Hello, I am starting to work with mysql and php. Does anyone know where to get a hosting that is free and that supports MySql and PHP. I would like to try out first before purchase a parking space on the internet. One of the fantastic qualities of MySQL, PHP, and Apache is their incredible platform support. If you have a computer, and I am assuming that you do, you can host your own web site. Apache, MySQL, and PHP will all run on the ever popular (and I will spare you on my thoughts on this) M$ Windows. If you have some sort of special circumstance or need, I might be talked in to giving you space and access on my server. But, my servers do not have telnet nor ftp installed. You will have to be competent with SSH to use one of my servers. Sincerely, Charles Quesenberry Thanks in advance Marnix - 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
