MySQL

[jdp2234]

Hello!

pzc.ozclans.com

My whole site runs on the database, so I really need it before i upload it all, so i can set it up for it

If someone can tell me how i can remotly link up to my home db, im more then happy to use that one, except i dont have a domain, so it's hard for me to link it up.

ie.

$this->host = "localhost";
$this->db = "nottelling";
$this->user = "nottelling";
$this->pass = "nottelling";
$this->link = mysql_connect($this->host, $this->user, $this->pass);
mysql_select_db($this->db);
$result = mysql_query("SELECT * FROM nottelling", $this->link);

I wanna change this code so it links not to localhost but to my home pc, but If i can get a db here, then im more then happy to do so

[Lego]

To your home PC? I guess that could be possible - just change the localhost to your IP address? Your database will have to allow connections from "yoursubdomain.ozclans.com"

I can also set up a database here on ozclans for you if you wish?

[jdp2234]

Well, I guess a db here would be betta, out of interest, how do I get MySQL to accept connections from ozclans?

[Lego]

Umm. You would have to edit the grant permissions for your username. So if you had a mysql user called "bob", you would have allow his hostname to come from "lima.ozforces.com"

I really only know how to do it via phpmyadmin.

I'll set up your mysql account on ozclans - you shall recieve details by email soon.

[jdp2234]

Cheers

[jdp2234]

You havent sent me it yet.

[Lego]

Done - check your email.

[jdp2234]

It doesnt appear to be working.

[Lego]

The login doesn't work? Try logging in below
http://myadmin.ozclans.com

[jdp2234]

Yeah, it says "#1045 - Access denied for user: *******@*******' (Using password: YES)"

[Lego]

Could you please reply to the email that was sent to you that contains the mysql details? I'll have to change your password. The system doesn't seem to be working, I'll have to have another look at it.

[jdp2234]

sent