Mysql database

[Guest sarvesh]

I am not able to connect to Mysql database although it is installed.I wants to use mysql database with Perl language.What should I do?????

Plz suggest me an alternative database which I can use in Mandriva 2009

Edited December 11, 2008 by sarvesh

[ianw1974]

Please check that the mysqld service is started, you can do this with a command from the console:

 

su (enter root password when prompted)
service mysqld status

 

if it's not running, do:

 

service mysqld start

 

Check if it's enabled to start at reboot:

 

chkconfig --list mysqld | grep :on

 

if no service is reported (eg: results from the command are blank), do:

 

chkconfig mysqld on

 

and when you reboot, mysqld will start.

 

PS - welcome to the forum!

[tyme]

follow ian's instructions first, as chances are you can't connect because it's either not started or not properly configured. also, if you are trying to connect remotely, make sure your firewall isn't blocking the necessary port (3306). if you're trying to connect locally, use "localhost" as the server name.

 

as for alternatives, there are many: postresql, sqlite, etc. - search the software installer for "sql" and you should see a few options.