starting mysql problem

scoppc

well, I can see the file /etc/mysql/my.cnf and both "mysql" and "test" table also exist on my debian box.
but when I typed "mysql", it said something like "unknown command"

how to start mysql and where should I type? is it in /bin ? /usr/local? or ???
I'm a completely noob for linux... pls help.

Thx

nashirak

Try /usr/bin/mysql

/usr/local/mysql

You can also do a

$ locate mysql | more

which will pull up all files that have the term mysql in them. Also edit your shells config file (.zshrc or .bashrc or .kshrc or whatever) include the following:

First type:

echo $PATH

and see if /usr/local and /usr/bin are in there, if edit this in the file (or simply type it on a command line to edit this temporarily)

PATH=$PATH:/usr/local:/usr/bin

Then simply login again (if you are editing the file), or type

rehash

if you are simply editing the variable on the command line.

Hope this helps!

scoppc

Ok, have tried to locate using ur method and I used 'mc', too.
The one that I can find is 'my.cnf' and 'mysql' folder containing the data files.
Is that mean that MySQL is not yet installed?

If yes, can I install RPM package under Debian or I must use .tar.gz??

One similar problems i faced on my Redhat Box at home. (Debian is the computer in my office), I tried to install RPM package of MySQL-server-4.0.13-0.i386.rpm and also MySQL-client-server-4.0.13-0.i386.rpm but it seems like mysql-3.23.54a-11 is already installed.
I tried to Upgrade by using the -U parameter but failed coz it said there are file dependencies for 'libmysqlclient.so.10' for some package such as php-mysql-4.2.2-17 and some others.

I deleted the old Mysql by 'rpm -e --nodeps mysql-3.23-54a-11' and re-install new MySQL RPM package...
Now, I can access MySQL console but... mysql_connect function in PHP didnt work!

Have tried for almost a week now... going insane...

nashirak

Ok type this:

dpkg -l mysql-common

If you dont get something like:

Name                              Version

mysql-common 4.0.13-3

Then you dont have mysql-common installed. And you need to install it.

Excuse my forwardness but do you know about apt? I am seeing you manually installing debian files and rpms... etc. (You might have a reason but just in case I will explain more). A typical debian box's programs are installed through apt. So lets say I want mysql-common so I will say

apt-get update
apt-get install mysql-common

on the command line. It will go to a few known servers update a list of packages. Then install the mysql-common package. You shouldnt have to manually install anything. It will even tell you about dependency problems and fix them for you. If you do know about this, sorry to waste your time, if you dont, USE IT! It makes life a lot easier.

To answer you other question about RPMs. Yes you can install an RPM in debian. There is a package called "alien" it will convert RPM's too debian package files (.deb). But this is not a preffered way of installing programs.

As for why you are not able to connect to mysql through php I believe the problem resides in the fact that you need a bridge between mysql and php or a mysql.so under your /usr/lib/php4/ directory (might be a little differnet). To install this simply:

apt-get install php4-mysql

I hope all of this helped!

scoppc

Thanks alot, man! I'll try every suggestions and ways to get it working. As for the 'apt' thing... know nothing bout it. So, again... thanks for that.