Anyone had this problem before?

[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][e-mail][/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.