mysql_connect('help!!')

[Brennen]

I write:
mysql_connect('localhost', 'root', 'password')

which works fine, but I want to reference the IP number instead referencing localhost, like so:
mysql_connect('111.222.333.444', 'root', 'password')

and this doesn't work!!!! why

This has been bothering me for a few days now, and I need to get this fixed, it is driving me insane!!

if you can help me, you'll be my hero!!!

[wmk86]

try using double quotes (") instead of the single quotes

[pedro_gb]

You want to know the IP for localhost? That's always 127.0.0.1, so the code'll be:

mysql_connect ("127.0.0.1","root","C0ol"); 

[freakysid]

If you want to access a mysql server on another computer over a network. php/mysql won't allow this under the default settings. You gotta mess with something to get that to work. Don't know what though off the top of my head.

[freddydoesphp]

You need to make sure that your user has access to access the database from a remote server. In your database in the mysql database > user table

For instance if root needs to access the database from a remote server(keep in mind opening up root privileges outside the localhost is not advised(sp?)) but this is what it would look like

mysql> select * from user;
+-----------+-----------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+-----------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| % | root | *********** | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |



Notice the Host column is set to %, this means okay from any host. Just make sure your user has the right permissions. Chances are right now it says localhost in that column which means this user can only connect from localhost in other words the computer where the script is living.

[Kevin Yank]

Here's the section of my PHP/MySQL series that coveres these idiosynchrasies of MySQL's access control system:

http://www.webmasterbase.com/article.php/228/968

[westmich]

Is there a descripancy between those last two answers? I thought Kyank's article said to set-up two users, whereas, freddydoesphp says to use the % wildcard.

[westmich]

I was having a similar problem of only being able to connect using localhost. I changed my user info to "%" instead of "localhost" and now it lets me connect as 127.0.0.1, but not as my actual IP address "http://24.10.xx.xx" (I'm on a cable modem I can reach my computer from outside via this IP with IIS or Apache running).

[Kevin Yank]

Read the section of my article referenced above closely. The problem actually stems from two default entries in the 'user' table that should almost always be removed on a production system!