[PHP-DB] MySQL denying access to...everything
I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. If not, flame me for all I care. I'm too sick of all this mess to care. ...somebody help...
Re: [PHP-DB] MySQL denying access to...everything
This is a MySQL error on the server side - you need to make sure that whatever user you're signing into MySQL with has access to modify the database/table you're using. I believe the GRANT keyword in MySQL is what you need -- look at the MySQL reference manual: http://dev.mysql.com/doc/ Good luck! -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-08-17 at 23:03 -0400, [EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. If not, flame me for all I care. I'm too sick of all this mess to care. ...somebody help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL denying access to...everything
Also, take care with the new password hashing: http://dev.mysql.com/doc/mysql/en/Password_hashing.html Paul On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis [EMAIL PROTECTED] wrote: This is a MySQL error on the server side - you need to make sure that whatever user you're signing into MySQL with has access to modify the database/table you're using. I believe the GRANT keyword in MySQL is what you need -- look at the MySQL reference manual: http://dev.mysql.com/doc/ Good luck! -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue, 2004-08-17 at 23:03 -0400, [EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. If not, flame me for all I care. I'm too sick of all this mess to care. ...somebody help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL denying access to...everything
[EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what. If not, flame me for all I care. I'm too sick of all this mess to care. ...somebody help... http://dev.mysql.com/doc/mysql/en/User_Account_Management.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL denying access to everything...Part 2
Ok, thanks to many people's help, I have managed to install MySQL right and login as root with no password. However, MySQL will not allow to log in to my databases as root. Is this normal, because when I try it brings back the old access denies: [EMAIL PROTECTED] thing. So I thought maybe I just have to figure out how to create accounts, and then configure them to be all access. I have read the manual on creating accounts, but for some reason it doesn't work. Here is how it goes: I access mysql.exe and put in this: mysql GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' Then I hit enter. It starts me off with an indented down arrow and I finish the GRANT command. - IDENTIFIED BY 'password' WITH GRANT OPTION; Then I hit enter. IT gives me another down arrow. I hit enter again and again and again and all it does is give me more indented down arrows... What now?
Re: [PHP-DB] MySQL denying access to everything...Part 2
This isn't the appropriate list to direct this question to. I suggest one of the MySQL help lists or a careful reading of the documentation, which tells you exactly what you need to know. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Wed, 2004-08-18 at 14:43 -0400, [EMAIL PROTECTED] wrote: Ok, thanks to many people's help, I have managed to install MySQL right and login as root with no password. However, MySQL will not allow to log in to my databases as root. Is this normal, because when I try it brings back the old access denies: [EMAIL PROTECTED] thing. So I thought maybe I just have to figure out how to create accounts, and then configure them to be all access. I have read the manual on creating accounts, but for some reason it doesn't work. Here is how it goes: I access mysql.exe and put in this: mysql GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' Then I hit enter. It starts me off with an indented down arrow and I finish the GRANT command. - IDENTIFIED BY 'password' WITH GRANT OPTION; Then I hit enter. IT gives me another down arrow. I hit enter again and again and again and all it does is give me more indented down arrows... What now? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL denying access to everything...Part 2
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'password' with grant option; try this out balwant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 12:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL denying access to everything...Part 2 Ok, thanks to many people's help, I have managed to install MySQL right and login as root with no password. However, MySQL will not allow to log in to my databases as root. Is this normal, because when I try it brings back the old access denies: [EMAIL PROTECTED] thing. So I thought maybe I just have to figure out how to create accounts, and then configure them to be all access. I have read the manual on creating accounts, but for some reason it doesn't work. Here is how it goes: I access mysql.exe and put in this: mysql GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' Then I hit enter. It starts me off with an indented down arrow and I finish the GRANT command. - IDENTIFIED BY 'password' WITH GRANT OPTION; Then I hit enter. IT gives me another down arrow. I hit enter again and again and again and all it does is give me more indented down arrows... What now? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
