RE: MySQL/PHP

["Dave Grummer" <dave@example.com>]

Dear Ahmed,

First if you want to see where mysql is installed, type "which mysql".

Next you need to startup the mysql database. First you can check if it is
started up by looking for the process "ps -a". If it is not started go to
the bin directory and find mysqlstartup. This might be the incorrect
executables name but I know mysqlshutdown is how you shutoff the database.
Type mysqlstartup and then verify that the DB is up.

When I login to mysql to get this is what I use:

mysql -u USER -pPASSWORD DATABASE

Note: There is no space between the -p and the password.

Check the docs for what the default login is and after you login and get the
mysql prompt make sure to edit the table with the users information and
create a new db.

Best Regards,
Dave Grummer


-----Original Message-----
From: Ahmed Sarwar Liton [mailto:leyton@example.com]
Sent: Sunday, July 15, 2001 11:09 PM
To: Linux User group Tokyo
Subject: MySQL/PHP


HI,

I have been trying so hard to make a connection with
my MySQL by typing these:

[root @example.com liton]# mysql -u root create mydb
mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql//msql.sock' (2)
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock'
exists!

I absolutely have no idea about what this means. Can someone help?
Thanks in advance.

Liton

-----------------------------------------------------------------------
Next Nomikai Meeting:    Fri, Aug 10 19:30-  Tengu Tokyo Eki-Mae
Next Technical Meeting:  Sat, Sep ?? 13:30-  Akasaka Kumin Center
-----------------------------------------------------------------------
more info: http://www.tlug.gr.jp           Sponsor: Global Online Japan