installed mysql 5.0 and mysql command not available
 

hello
I installed mysql from sources; i downloaded a tar.gz and didn't had to run ./configure etc; jsut like that
but I don't know how to create databases? when I type in the shell %mysql -u root

the shell tells me command not found. do I have to unistall it and reinstall it? there are any deb packages to install mysql 5?
thank you in advance.
mario

hi
Actually after installaion you have to start the mysqld deamon.Check whether mysqld deamon started. The mysql client is also provided in the MYSQL source directory

command: Change your directory to the mysql bin directory in the source(from where u have done ./configure etc).
#./mysqld &
#./mysql

hope it works....

in fact the issue is that it's not configured int he batch.. anyway yesterday i was making the wrong installation, today I did the right installation and to be able to have a prompt like
mysql>
i have to go to the directory I installed mysql and type bin/mysql -u root -p

it's there a way to add it to the patch or something like that..
something else, i don't know how to make it on start on debian;. like an script on /etc/init.d/.. i always have to start mysql manually again running to the installation directory which by the way it's on /usr/local/mysql.
thank you in advance.
mario