Re: MySQL Connection
| From: | moses dot johnson at btopenworld dot com | Date: | Wed, 18 Jun 2003 01:19:57 +0000 |
| Subject: | Re: MySQL Connection | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-151921@lists.php.net to get a copy of this message | ||
Hello, This seems not to be working, I am using win2000 and a newbie. please simplify this process.
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql> GRANT ALL PRIVILEGES ON *.* TO moses@localhost
-> IDENTIFIED BY 'cludiana' WITH GRANT OPTION;
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql>
Regards
> from: Lars Torben Wilson <torben@php.net>
> date: Wed, 18 Jun 2003 01:17:15
> to: moses.johnson@btopenworld.com
> cc: php-general@lists.php.net
> subject: Re: [PHP] MySQL Connection
>
> On Tue, 2003-06-17 at 17:13, moses.johnson@btopenworld.com wrote:
> > Hello,
> >
> > Would be grateful if someone couldkindly point me in the right direction.
>
> Check the MySQL documentation. You also might want to ask on the MySQL
> mailing list.
>
> http://www.mysql.com/doc/en/Default_privileges.html
> http://www.mysql.com/doc/en/Access_denied.html
>
> It appears, however, that mysqld is not recognizing the authority of
> whoever you're connected as to modify the grant tables. Try connecting
> as the admin user.
>
>
> Good luck,
>
> Torben
>
> > Whenever I try to connect to mysql server, I get these messsage back
> >
> > 1.
> > mysql> GRANT ALL PRIVILEGES ON *.* TO moses@"%" IDENTIFIED BY
> > mysql> "cludiana";
> > ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> > mysql>
> >
> > 2.
> > mysql> GRANT ALL PRIVILEGES ON *.* TO moses@"%" IDENTIFIED BY
> > mysql> "cludiana";
> > ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> > mysql>
> >
> > what could be wrong. Help please .
> >
> > Regards
> >
> > Moses
> --
> Torben Wilson <torben@php.net> +1.604.709.0506
> http://www.thebuttlesschaps.com ß®ë
> ᕨаֳm:http://www.inflatableeye.com
> http://www.hybrid17.com
> http://www.themainonmain.com
> -----==== Boycott Starbucks! http://www.haidabuckscafe.com
> ====-----
>
>
>