Anyone had this problem before?

piersk

System: Win XP Pro, Apache 2.x, PHP 4.2.2

Im trying to install MySQL. I had it installed before, but for some reason after a while I couldnt connect to it. So I thought Id upgrade to the latest version (v 3.23.52). The uninstall and re-install went ok, and I was asked for a new user name and password for root access (all perfectly normal). I restarted my computer (force of habit more than anything else) and tried to connect to the server, first using PHP and then using the command prompt.

I found that I couldnt connect, unless I specified blank as the hostname. for example, when connecting using the command line: c:\mysql\bin\mysql.exe -h -u piers -p (you will notice the lack of a hostname after the -h).

I tried to connect to localhost using PHP, but i got the message: "Can't connect to host "localhost".

So I tried running this:

<?php
$user="piers";
$password="****"; // No this isnt my real password, I just didnt want to broadcast it out...
$server="";

$connect=mysql_connect($server,$user,£password);

?>

And this worked fine.

Now, I hear you ask, what is he complaining about? He can connect to his MySQL server with no problems.

The problem is that I rely quite heavily on phpMyAdmin when working with my databases, and you cant specify "" as a server; it doesnt like it, and if I type "localhost" then it wont connect.

I just wanna know if anyone has had this sort of problem before, and if they fixed it, how did they fix it?

Apologies about the length of this post, but I REALLY need to know what the heck is going on...

Mark

try your computers name as the host name :p

piersk

Already tried it. It failed.

Mark

well poop... :\ ummmm. hold, lemme charge up my stupid gene's, see if they come up with a 'solution'😃

Mark

you dont happen to have the username and pass set in the php.ini file do you?

piersk

Good idea, but no.

adslworld_net

Piersk,

Not the best on sql but if you are using phpmyadmin have you checked the settings in the config.inc.php file for the

$cfg['PmaAbsoluteUri'] = 'http://localhost/admin/';

setting and put the path to your phpMyAdmin folder in there i.e. mine sits in the admin folder on localhost as above path.

I also change the following in the config.inc.php file for my sql server settings that you would have been asked for when you installed mysql again and ran the winmysqladmin.exe in the bin folder of mysql:

$cfg['Servers'][$i]['user'] = 'xxxxxx';

$cfg['Servers'][$i]['password'] = 'xxxxxxxxx';

After that I have no problems in connecting to SQL and using phpmyadmin etc... You are running SQL as a service after running the winmysqladmin.exe file and installing the service I take it?

adslworld_net

oh yeh and check the my.ini file has the correct settings as well, should look like:

#This File was made using the WinMySQLAdmin 1.4 Tool
#19/08/2002 22:01:17

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=xxx.xxx.xxx.xxx (your local IP addy)
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=xxxxxx
password=xxxxxxxxx

Set your user id and password up in the last 2 lines above and make sure the bind address is correct for your local IP addy.

piersk

sob nope, didnt work

adslworld_net

hmmmm....thats weird...

So maybe now its the uninstall, clear out and reinstall stage...

:eek:

piersk

I tried that but it didnt work. Ive even tried going back the the version before, but that didnt work either...

piersk

OH MY GOD!!!!

Ive now tried using Fox server (see ADSLworld for more details) but IM STILL HAVING PROBLEMS!!! PLEASE PLEASE PLEASE (and im sorry for shouting, but this is REALLY getting on my nerves) WILL SOMEBODY HELP ME!!!!!!

ahem.... sorry for that....

tdevlin

This may seem like stupid reply and generally a very simple one, but there is two things needed to answer this question appropriately, first are you running the script from the same server that your mysql is installed on? (IE: Webserver and Mysql same computer? "localhost").

If the answer is yes, then make server named "localhost" and make sure all of the correct properties are setup in your mysql database, First under table "host" make sure localhost is setup there, with the proper abilities, hosts should have no rights/privilages, EX: under database mysql, table hosts, fields select_priv/update_priv etc should all be marked as "N" for no. The next step is to make sure your login user is setup and with appropriate settings, the user needs to have the field host setup as same as the host, IE: localhost, and again all the rights/privs are set to N. With the exception of root (in most cases).

And finally make sure your db table is filled out correctly with appropriate permissions for the user/host/db and that they all match the user table and host table.

If the answer is no, then you need to add your server to the list of hosts in the host table under mysql database, you can pretty much follow the steps above for this also.. If host != localhost, write your hosts like this EX: osprey.airewaves.com (thats my server named address).

If you have any more problems please feel free to send me an email or reply to this forum and I'll try my best to help you.

+------------------------------------------+
|          ___________   _______           |
|         //_/_/_/_/_/  //_/_/_/           |
|            //_/      //_/   _/           |
|           //_/      //_/   _/            |
|          //_/      //_/_/_/              |
+------------------------------------------+
| Tony Devlin - [email]tdevlin@airewaves.com[/email]      |
| Airewaves Broadband, Systems Admin       |
| Website - [url]www.airewaves.com[/url]              |
| Atlanta, Ga - 678.522.3923               |
| Beaufort, SC - 843.379.1720              |
+------------------------------------------+

piersk

Well, I think I've found out what was wrong... the host table was empty!!! Not quite sure why, but anyway.

When populating this, what needs to go into the field "Db" in the host table for localhost?

piersk

Anyone? Please help! I have very little hair left to pull out....

PHPendeavor

Hi there,

I'm new to this forum and have taken an interest in PHP. I too had the same problem as you Piersk!! It B]was[/B] frustrating!!

I have win XP - home edition running Apache 2, mySQL 3.23 and PHP 4

What I did to resolve the problem was to rename one of the my-size files in the mysql dirctory (where 'size' is small, medium, large etc...) to my.ini and plonk it in the windows directory!!!

For example I changed my-medium to my.ini

Hope you retain what little hair you have left!!! I'm from the UK too!!!😃

The_Chancer

Try this one out for size:

CREATE TABLE host (
  Host char(60) NOT NULL default '',
  Db char(64) NOT NULL default '',
  Select_priv enum('N','Y') NOT NULL default 'N',
  Insert_priv enum('N','Y') NOT NULL default 'N',
  Update_priv enum('N','Y') NOT NULL default 'N',
  Delete_priv enum('N','Y') NOT NULL default 'N',
  Create_priv enum('N','Y') NOT NULL default 'N',
  Drop_priv enum('N','Y') NOT NULL default 'N',
  Grant_priv enum('N','Y') NOT NULL default 'N',
  References_priv enum('N','Y') NOT NULL default 'N',
  Index_priv enum('N','Y') NOT NULL default 'N',
  Alter_priv enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY (Host,Db)
) TYPE=MyISAM COMMENT='Host privileges;  Merged with database privileges';

Should sort it all out !

piersk

Well, since starting this thread, Im not really sure what Ive done, but it seems to be working ok. All Im doing is to connect to the MySQL server using the hostname "" (and yes, I do mean that Im not specifying a hostname). It probably works since both my webserver and MySQL server are running off the same computer. PHPMyAdmin doesnt seem to like it, but Im using a program called MySQL-Front which works fantastically. (I'll edit this and put a link to the download when I find it).

Thanks to all those who gave suggestions.