how do i use MySQL? i get errors...

[Chooco]

i installed the latest MySQL by extracting the file so that the folder of mysql is /usr/local/mysql
as root i went into the mysql/bin and tried these commands:
./mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
./mysqladmin
gives a whole ton of possible commands...

in the list of commands i didn't see anything that appeared to be the command to make a new host or define it or something like that.....how do i create a mysql host?
it's either i do the MySQL thing or i try to figure out how the heck to use Perl, this seems easier lol 😉

 

[Nothinman]

You need to run mysqld first, it's the daemon that actually does the database stuff.

Why didn't you install the RPM? That would have put startup scripts and man pages in easily found places...

 

[Armitage]

Yep, what nothingman said. You have to run the server (mysqld) before the client (mysql) will work.

To see if you're running the server:

ps -fea | grep mysqld

I'd suggest a visit to the mysql documentation is in order. It's really pretty good.