Re: MySQL Connection
| From: | daniel at electroteque dot org | Date: | Wed, 18 Jun 2003 01:22:45 +0000 |
| Subject: | Re: MySQL Connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-151923@lists.php.net to get a copy of this message | ||
this is a mysql specific question
i think u have to go flush privileges;
after you do that
> 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
>> > "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
>> > "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
>> http://www.inflatableeye.com
>> http://www.hybrid17.com
>> http://www.themainonmain.com
>> -----==== Boycott Starbucks!
>> http://www.haidabuckscafe.com ====-----
>>
>>
>>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php