Setting MySQL on port 8306

[boba5555]

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.

 

[JackL]

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.

 

[boba5555]

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.

 

[sergius]

Hello boba5555,

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