Changing DB port?

[katos]

Hey guys!

 

usually I am fine with this stuff, but I have tried to change my port for MySQL from 3306 (default) to 3307 - after I had to migrate due to issues with my database.

So, I opened conf_global.php and changed it to suit my port:

 

I tried both:

$INFO['sql_driver'] = 'mysql';
$INFO['sql_host'] = ''xxx.xx.x1.13';
$INFO['sql_port'] = '3307';

 

and 

$INFO['sql_driver'] = 'mysql';
$INFO['sql_host'] = 'xxx.xx.x1.13:3307';

But on both attempts I get: 

 

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. 

You can try to refresh the page by clicking here

 

Am I missing a configuration or ...?

Many thanks,

Katos.

Edited July 29, 2014 by katos

[katos]

You are restarting mysql after adding the port=3307 ??

 

Also try rebooting or restarting xampp.

 

I did do, neither worked.

 

I have resolved this issue myself by clearing the users and remaking them, then reimporting the databases. Very strange, but at least it worked.

Huge thanks for all of your help Lock_down much appreciated.

[Lock Down]

Why is the sqlhost not "localhost" ? Then 3307 for port.

 

Also have you looked at the mysql logs in /var/logs

[katos]

Why is the sqlhost not "localhost" ? Then 3307 for port.

 

Because the database is on a seperate host, but I think I could fix it by migrating the database to the localhost of the machine actually, never thought of that (can't believe I didn't but there we are...)

Thanks for that, will try this!

--- EDIT ---

 

My database is on a VPS but my website is on a dedicated webhost - is there anyway I can fix this and maintain this structure or do I have to have the database on the localhost?

[Lock Down]

You are welcome. It may be a iptables or firewall error on the remote host for port 3307 and your website ip address.

[katos]

Very strange, I have allowed the port "3307" in the firewall for in AND outbound connections, and still getting the error:

 

[Lock Down]

Did you edit the /etc/my.cnf file on vps and add port=3307 after socket=/var/lib/mysql/mysql.sock

[katos]

Did you edit the /etc/my.cnf file on vps and add port=3307 after socket=/var/lib/mysql/mysql.sock

Bollucks. Totally forgot that, will try this later when I am back home, thanks!!

[Lock Down]

Good luck.

[katos]

Good luck.

 

Still got the issue. No idea what is going on, using Xampp for the Mysql at this moment (the site is NOT hosted with Xampp.)

[Lock Down]

You are restarting mysql after adding the port=3307 ??

 

Also try rebooting or restarting xampp.

[Lock Down]

You are welcome.

[Skreamzja]

The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.

If you have other questions, please open a new topic.