Jason - I just tried: GRANT ALL ON *.* TO [EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' <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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > 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: '[EMAIL PROTECTED]' <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: >>'[EMAIL PROTECTED]' (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: '[EMAIL PROTECTED]' (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! >> > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]