Install MySQL on Solaris 9 problem

[Chimpfu443]

I have installed MySQL on Solaris 9 from a package I downloaded from Sunfreeware.com

The problem is if I attempt to start it, i get the following:

root@javaweb # /usr/local/mysql/bin/mysql
ld.so.1: /usr/local/mysql/bin/mysql: fatal: libncurses.so.5: open failed: No such file or directory
Killed

ANy ideas.

 

[TonyGroves]

I'm not a Solaris user, but I suppose that means you haven't got the ncurses library installed. It's probably available as a package from the Solaris repository.

 

[Chimpfu443]

Thanks, that took care of the ncurses error. Now the next one is:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@javaweb # find / -name mysql.sock
root@javaweb #

I can't even find the mysql.sock, any ideas?

rgds
CC

 

[TonyGroves]

Is the server running? To start it, use the command "mysqld &".

 

[Chimpfu443]

It not running

I get the error when I try starting it.

Check:

root@javaweb # /usr/local/mysql/bin/mysql &
[1] 422
root@javaweb # ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[1]+ Exit 1 /usr/local/mysql/bin/mysql

 

[TonyGroves]

That was "mysqld &" to start the server. "mysql" is the bundled client program.

 

[Chimpfu443]

Sorry Tony, you lost me there,

you mean how to start mysql is not via /usr/local/mysql/bin/mysql ?

What is the command to start it then?

 

[TonyGroves]

First, you must have the MySQL server ("mysqld") running silently in the background. Normally, it would be started automatically by a system startup script. To start it manually, you can use "mysqld &". You can check to see if it's already running with "ps -A | grep mysqld" which should print one or more lines (at least that's how I'd do it in Linux).

Then, you can connect to the server using a client program, such as "mysql" which is included in the MySQL package. The command for that would be something like "mysql -u root". You will then get a mysql prompt, which allows you to enter SQL statements to be processed by the server.