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.
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.