• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Setting MySQL on port 8306

B

boba5555

Guest
Dear,
I have a problem with MySQL and Plesk. At first, I will describe you state of some files

C:\SWSoft\Plesk\MySQL\Data\my.ini file contains
[PleskSQLServer]
port=8306
.
.
.
skip_grant_tables=1
[client]
port=8306


Services:
PleskSQLServer - 'executable file' property holds "C:\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe" --defaults-file="C:\SWsoft\Plesk\MySQL\Data\my.ini" PleskSQLServer

I've restarted this service.
I also have C:\SWSoft\Plesk\Databases\MySQL, but I haven't touch that :)

In C:\SWSoft\Plesk\MySQL\bin there is file MySQLInstanceConfig.exe. I tried to set mysql to work on port 8306, but it didn't help me, so I started that file again and removed instance (I was trying that and before and after changing file my.ini).


When go to plesk -> Server -> DatabaseServers, there is some mysql which has red icon, I suppose it is not important. I also tried to add new DB server. I filled data like this:
Database server type - MySQL
Host name or IP address - localhost
Port number - 8306

Authentication:
Administrator's login - admin
Administrator's password - [password] (later I will explain about that)
Confirm: same as above


With C:\SWSoft\Plesk\MySQL\bin\mysql -P 8306 -u admin -p
I am asked about password. Here I input same password as administrator's password is ([password]). I can create database, view it and so on.


I want to set mysql so it is listening on port 8306. I also want to be able to see MySQL DB through plesk. In my ASP files I use this line to connect
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; Port=8306; DATABASE=[dbname]; UID=admin;PASSWORD=[password]; OPTION=4


I have no idea what I should do. Can someone help me, please?

Thank you in advance.

EDIT:
I've read <a href="http://forum.swsoft.com/showthread.php?threadid=31434">this</a> page. Now I'm thinking about another mistake. So, if I want to use [dbname] which is clients' database, should I set that in C:\SWSoft\Plesk\MySQL\Data (I restored [dbname] with mysql -u admin -p [dbname] < [dbname].sql) or in C:\SWSoft\Plesk\Databases\MySQL\Data?
If I use both services, which ports I should set? Should I use Plesk reconfigurator? I will appreciate if someone give me detail description of setting up those stuffs. Thank you again.
 
You can use that (8306 mysql) in Plesk.
Just add server on Plesk CP -Server-Databases page as following
8306, localhost , admin and Plesk admin password.
nd as another database you can add one which is on 3306

John S.G.
 
I've tried but I can't add DB server.

my.ini file contains
---------------------
[PleskSQLServer]
port=3306
...
[client]
port=8306
---------------------

What is the difference between those ports (in my.ini file) ?

Plesk\Databases\MySQL\bin\mysql -P 8306 works
Plesk\MySQL\bin\mysql -P 3306 works - different port from above

In Plesk I see -P 3306 DB.

When I try do add DB server I do next:
hostname: localhost
port numer:8306

administrator's login: admin
password: [password]
confirm pass;[password]

and press 'Ok' button
After that I get this message "Error: Some fields are empty or contain an improper value."

In list of MySQLs, there is already MySQL on port 3306 (I suppose it is plesk\mysql). When I try to change its port, I get the same message.

Can you give me some further advice? Thank you.
 
Hello boba5555,

Please does not allow to register two external SQL servers as localhost - you should use other name for second server.
 
Back
Top