Printable View
I have downloaded the trial versions of PremiumSoft Navicat v 5.11 and PemiumSoft MySQL Launcher v3.23.55. When I start MySQL Launcher, start server, I get an error message saying 'error trying to perform specified action' and when I try to connect with PremiumSoft Navicat v 5.11 it says, could not connect using root@localhost.
Can someone please point me in the correct direction to rectify this.
Regards
rossifumi
Is MySQL installed on the same box? What parameters were used?
The connections error to root@localhost is the default MySQL root loggin failing - probably because MySQL is not running OR the default root user does not have sufficient privileges anymore ( or doesn't even exists anymore ).
We need some more info :(
Cheers
Many thanks for your reply. I have Navicat and MySQL launcher installed. When I try to open the default connection I get the 'could not connect using root@localhost' error and when I start up MySQL launcher and try to start server it says 'error trying to perform specified action - error message', the service has been started and I can select remove service if I so wish. As far as I can see everything else is ok. PLease help.
Cheers
R
I can suggest the following at this point:
1) Ensure the process is infact running. I am not familiar with the Windows OS, but on *nix I would do:2) If the MySQL process is running, is it listening for connections? You should be able to use the netstat command for that. Again, in *nix I would use:Code:$ ps -aux | grep mysql
This only means: "is there something listening on port 3306?".Code:$ netstat -natup | grep LISTEN | grep 3306
3) If both the previous checks out, try the command line mysql client. In a DOS box ( you still have those, yes? ) simply type:. You should get something similar to:Code:> mysql
PS: You might need to to specify the path to the mysql binary.Code:$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.11a-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.14 sec)
mysql>
If all works, then your problem is purely Navicat related, in which case you should contact their tech support. If you have problems with anything from 1 to 3, your problem is MySQL related - and we then need to dig a bit more.
Cheers.