Re: MySQL Connection

From: 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 > ====----- > > >

« previous php.general (#151921) next »