topic Re: msyql client in Operating System - Linux

msyql client

yuk1 — Mon, 01 Sep 2008 15:38:34 GMT

I have already install the mysql package to the debian includes

libdbd-mysql
libmysqlclient
mysql-client
mysql-common
mysql-server
php4-mysql
webmin-mysql

then I want to run "mysql" command to use as mysql client , but it pops "commond not found" , could advise what package that I should install so that I can run "mysql" ? thx

Re: msyql client

Ivan Krastev — Mon, 01 Sep 2008 18:37:27 GMT

Use dpkg to obtain package name for specific file. In debian mysql client binary is located in /usr/bin/:

# dpkg -S mysql | grep bin
mysql-client-5.0: /usr/bin/mysql

Check for your client in /usr/bin, check also $PATH variable and fix it if necessary.

regards,
ivan

Re: msyql client

yuk1 — Mon, 01 Sep 2008 22:37:18 GMT

thx reply,

I tried to use dpkg -S mysql | grep bin to find that the mysql is in /usr/bin , but when I run it , it pop no such file , can advise what is wrong ? thx

#dpkg -S mysql | grep bin

"
mysql-client-4.1: /usr/bin/mysql
mysql-client-4.1: /usr/bin/mysqladmin
"

Re: msyql client

Steven E. Protter — Tue, 02 Sep 2008 10:04:11 GMT

Shalom,

It appears the binary you found is for mysql version 4 and you are running mysql version 5.

Remove and re-install the package that provides mysql client.

SEP

Re: msyql client

Ivan Krastev — Tue, 02 Sep 2008 11:42:02 GMT

Try to run directly : /usr/bin/mysql and give an exact error from the program.

regards,
ivan

Re: msyql client

yuk1 — Wed, 03 Sep 2008 23:23:22 GMT

thx reply,

I have removed the mysql-server , mysql-client , mysql-common from my system , then I try to install it by apt-get -f install mysql*, apt-get upgrade mysql*, apt-get -f mysql*dist-upgrade mysql*, apt-get update , aptitude upgrade mysql* , but it still pop there is other dependences not installed , such as libc6-dev , then I tried to install this package , but it still pop the other package is not update , it also pop the coreutils is old version and asked to upgrade to newer version , but when upgrade the version of coreutils , it pop the dependence again , what I want to install is mysql4 server , client , can advise how can I install it without dependence problem ?

Re: msyql client

Ivan Krastev — Thu, 04 Sep 2008 09:42:35 GMT

Just try:
apt-get install mysql4-server

Of cource you should accept and install an additional software to met the dependencies.

regards,
ivan