472,782 Members | 1,153 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,782 software developers and data experts.

* HELP * MySQL Connection Issue - Access Denied!!

Content-Type: text/plain;
Content-Transfer-Encoding: 7bit

..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:
'r**********@' (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
"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.
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
o Local Host Name: 'SAMSERVER'
o Local User Name: ' Administrator'
o OS Platform: 'Whistler'
o Local IP Address: '
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!

Jul 19 '05 #1
0 3287

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Ryan Schefke | last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit ..I just sent this out to the win32 distribution list but no one has...
by: Vidhya CS | last post by:
hi , I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and...
by: James Woo via SQLMonster.com | last post by:
Hi All I am getting an access denied message when I launch the Virtual Server administration screen, however I can connect through the Virtual Machine remote connectivity without any problems....
by: powerfulhosting | last post by:
I'm trying to allow someone from a specific IP to connect to a mySQL db w/OBDC. I've run several GRANT queries on the mysql db i.e. GRANT select,update,insert,delete,create,drop,alter,index on...
by: rockdale | last post by:
Hi, all: My asp.net application calles MS speech 5.1 and generate a wav file on server's path. Everything runs perfectly on my development machine. But when I move the appl to production server,...
by: nickyeng | last post by:
Hi all, I have a question. The situation is like this. I have website and allow user to login and check their details. Every pages are jsp file and contented connection to mysql database to...
by: vozzek | last post by:
Hi all, I've got a mySQL database I've been working with as my localhost for several months now, no connection problems. I'm at the point however, where I need to connect to the database from...
by: pearl15 | last post by:
Hello All I have successfully installed the following IIS ver 6 php ver 4.4.9 MYSQL ver 5.0.67 when i tested through command line i get no error and i am view the php pages on the browser...
by: benicio | last post by:
i got this error after uploading all the files in www folder. i'm using wamp. Warning: mysql_connect() : Access denied for user 'root'@'localhost' (using password: YES) in...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.