List:General Discussion« Previous MessageNext Message »
From:Ryan Schefke Date:July 18 2003 3:09pm
Subject:RE: * HELP * MySQL Connection Issue - Access Denied!!
View as plain text  
Jason - I just tried:

GRANT ALL ON *.* TO ryanschefke@localhost IDENTIFIED BY 'XXXXX'

on the server machine in a mysql console and I got the following:
ERROR 1045: Access denied for user: '@localhost' <using password: NO>

...in addition to my questions below, why doesn't that work!  Ahhh!


-----Original Message-----
From: Ryan Schefke [mailto:ryanschefke@stripped] 
Sent: Friday, July 18, 2003 11:05 AM
To: 'Jason k Larson'
Subject: RE: * HELP * MySQL Connection Issue - Access Denied!!

Hey Jason - Thanks a ton for your help!  You're a lifesaver!

When I use 'localhost' for the below line:
C:\mysql\bin\mysqladmin -u root -h localhost password xxxx

It seems to work??? because the next line goes back to c:\mysql\bin
...was the password for root successfully changed then?

on the next line, I type
c:\mysql\bin\mysqladmin -u root -h samserver password xxxx 

...and oddly enough I get the following:
mysqladmin: connect to server at 'samserver' failed
error: 'Access denied for user: 'root@samserver' <using password: NO>'



Why doesn't it work when I use 'samserver' instead of 'localhost'????
In the winmysqladmin 1.4 tool under the environment tab it says my local
host name is 'samserver'...what I named my computer?



 

-----Original Message-----
From: Jason k Larson [mailto:jlarson@stripped] 
Sent: Thursday, July 17, 2003 7:19 PM
To: Ryan Schefke
Subject: Re: * HELP * MySQL Connection Issue - Access Denied!!

You probably should either a) not use SAMSERVER or b) not specify the
host or c) use 
localhost instead of SAMSERVER.

the mysql> prompt means you have successfully connected to the database
server, which is a 
very good thing.

As for the errors you probably need to create the ryanschefke user.  Or
just use root (not 
recommended).

once you are at the mysql> console try typing the following SQL
statement.
GRANT ALL ON *.* TO ryanschefke@localhost IDENTIFIED BY
'your-password-here';

then do:
FLUSH PRIVILEGES;

you should be able to proceed with mySQLAdmin at that point.

--
Jason k Larson


Ryan Schefke wrote:

> Hi Jason,
> 
> When I type: c:\mysql\bin\mysqladmin -u root -h localhost (I use
> 'samserver' for localhost...I hope that's right???)
> 
> I get a whole list of things...version, options, variable, commands...
> 
> 
> When I type: c:\mysql\bin\mysqlc -u root
> 
> I get welcome to the MySQL Monitor.......then 'mysql>' shows up.
> 
> 
> ...still getting errors though as mentioned below.
> 
> -----Original Message-----
> From: Jason k Larson [mailto:jlarson@stripped] 
> Sent: Thursday, July 17, 2003 6:08 PM
> To: Ryan Schefke
> Subject: Re: * HELP * MySQL Connection Issue - Access Denied!!
> 
> How about:
> 
> c:\mysql\bin\mysqladmin -u root -h localhost
> 
> or just:
> 
> c:\mysql\bin\mysqlc -u root
> 
> ??
> 
> --
> Jason k Larson
> 
> 
> Ryan Schefke wrote:
> 
> 
>>.I just sent this out to the win32 distribution list but no one has
>>replied.can someone on this list please help?  The issue should be
>>trivial for experienced MySQL users, I'm just a novice,  thanks!
>> 
>> 
>>Anyone - I've been racking my brain for the majority of the day and
>>scouring through the MySQL manual trying to figure out what is
> 
> wrong.can
> 
>>anyone please help?  
>> 
>>Here's my issue:
>> 
>>- Extracted files to C:\MySQL
>>- Ran setup.exe (everything went fine, using MySQL Admin 1.4 I can see
>>'mysql' and 'test' dbs installed)
>>- MySQL is running as a service and MySQL Admin 1.4 shows a green
> 
> light
> 
>> 
>>From the box that is running MySQL I try to set the root password in
> 
> DOS
> 
>>two ways and when I mention the host (believe it's 'SAMSERVER'
> 
> according
> 
>>to MySQL Admin tool) it gives me an error.
>>
> 
>
------------------------------------------------------------------------
> 
>>--------------------------------------------
>>O c:\mysql\bin\mysqladmin -u root password XXXXX    .. Works fine and
>>the next line goes back to my root directory of c:\mysql\bin
>>O c:\mysql\bin\mysqladmin -u root -h SAMSERVER password XXXXX    ..
>>Gives me the below error!
>> 
>>Mysqladmin: connect to server at 'samserver' failed
>>Error: 'Access denied for user: 'root@samserver' <using password: NO>'
>>
> 
>
------------------------------------------------------------------------
> 
>>--------------------------------------------
>>Also, when I try to connect to the database from another computer via
>>the web using http://samserver.sytes.net:8080/mysqltest.php
>>I get the following error (I've attached my mysqltest.php file too):
>>'Warning: mysql_connect(): Access denied for user:
>>'ryanschefke@stripped' (Using password: YES) in
>>C:\Apache\Apache2\html\mysqltest.php on line 20
>>Could not connect'
>>*** Note, I had to change my router settings to forward port 8080 to
> 
> my
> 
>>web server ip since my ISP blocks port 80.
>>
> 
>
------------------------------------------------------------------------
> 
>>--------------------------------------------
>>Also, I've successfully installed phpMyAdmin 2.5.2-rc2.  When I run
>>'http://samsever.sytes.net:8080/phpadmin/index.php' I get the
> 
> following
> 
>>message:
>>"Welcome to phpMyAdmin 2.5.2-rc2
>>phpMyAdmin tried to connect to the MySQL server, and the server
> 
> rejected
> 
>>the connection. You should check the host, username and password in
>>config.inc.php and make sure that they correspond to the information
>>given by the administrator of the MySQL server.
>>Error
>>MySQL said: 
>>Access denied for user: 'root@SAMSERVER' (Using password: YES)"
>>
> 
>
------------------------------------------------------------------------
> 
>>--------------------------------------------
>>Server Settings:
>>- Under MySQL Admin 1.4 on the Environment tab I see the following
>>settings:
>>            o Local Host Name: 'SAMSERVER'
>>            o Local User Name: ' Administrator'
>>            o OS Platform: 'Whistler'
>>            o Local IP Address: '192.168.1.102
>>            o ..also, in MyODBC window it finds driver 3.51 and API
>>level 2 and SQL level 1
>> 
>>- Chose 'username' and 'password' for MySQLAdmin.exe application
>>- MyODBC 3.51.06 installed - MySQL Connector/ODBC 
>> 
>>Running These Software Versions:
>>- Windows XP with service pack 1
>>- MySQL 4.0.13 for windows
>>- Apache 2.0.47
>>- PHP 4.3.2
>> 
>>Any help is MUCH appreciated!
>>
> 
> 
> 
> 



Thread
* HELP * MySQL Connection Issue - Access Denied!!Ryan Schefke17 Jul
RE: * HELP * MySQL Connection Issue - Access Denied!!Ryan Schefke18 Jul