MySQL download problem

rossifumi · #1 05-14-2003, 01:03 PM

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

nicc777 · #2 05-15-2003, 07:58 AM

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

rossifumi · #3 05-16-2003, 09:33 AM

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

nicc777 · #4 05-16-2003, 04:41 PM

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:

Code:

$ ps -aux | grep mysql

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:

$ netstat -natup | grep LISTEN | grep 3306

This only means: "is there something listening on port 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:

Code:

> mysql

. You should get something similar to:

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>

PS: You might need to to specify the path to the mysql binary.

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.