[i](Even though I listen LUCKY by Britney all the way while I was installing it)


[/B]


Theres your answer :P.

I just got my RaQ3 yesterday from 4ws.
And I tried to intall the MySQL to my box.

First, I tried with the .pkg file from cobaltnet, with no luck, it told me that there is some problems installing a .rfm file. I tried a few times, and rebooted, and tried again, still don't have luck. (Even though I was listening LUCKY by Britney all the way while I was installing it :P )

Then, I went to mysql.com , and upload mysql-3.23.32.tar.gz to my box. Then I followed the instruction at http://www.webmasterbase.com/article.php?aid=228&pid=44 .

After the "scripts/mysql_install_db", I should've installed MySQL. But the list at the CP showing the Installed Software didn't show up MySQL. And then, I tried to set the password and it told me "error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!"

Anyone has any idea?

And I would like to know how to uninstall the MySQL as well.






[Edited by Donovan on 02-01-2001 at 02:54 AM]

A few things..

One, I'm not sure it will show that as installed. In fact, I doubt it. Two, installing SQL is different than starting it. You have to start it, then set the user name and password. Not sure if you did this...

I didn't start it, and don't know how to. I am really a UNIX
dumby.

I just installed, and after that, there's two lines intructing me how to change password for root and my default site. Then I just followed it and typed.

And it showed the errors.

OK... Now I have come to this problem.

[root@www mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
010201 00:01:29 mysqld ended


[1]+ Done bin/safe_mysqld --user=mysqlusr
[root@www mysql]# bin/mysqladmin -u root status
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[root@www mysql]#

So anyone have any idea how to fix it ?

I think I saw some posts regarding this.

So while I am searching, please answer if you know.

Argh!!! Can't find the answer, waiting for someone to help me now.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[root@www mysql]# bin/safe_mysqld --user=mysqlusr &
[root@www mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
010201 02:07:58 mysqld ended

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Why does it end automatically?
I saw the bug page at the mysql.com doc, there is a bug which is caused by "mysqld daemon ended", wonder is this the same.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[root@www mysql]# bin/mysqladmin -u root status
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysqld.sock' exists!

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Someone help me!!!!

[Edited by Donovan on 02-01-2001 at 05:32 AM]

mysql> status
--------------
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

Connection id: 17
Current database:
Current user: root@localhost
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 hours 56 min 28 sec

Threads: 1 Questions: 40 Slow queries: 0 Opens: 9 Flush tables: 1 Open tables: 2
--------------

Is MySQL running anot ???

By the way, I remember that 3.22.32 is the version I am facing problem while installing it, and 3.23.32 is the version that I can install very smooth according to a tutorial.

But how come now it is 3.22.32 ?

It is running and it is version 3.22.32 but I don't know much about your problem.

Hi,

I had the same problem. Please read http://www.sitepointforum.com/showthread.php?threadid=14025.

Hope this helps!

Thanks for that link... I am looking through it now.

Cool...

At first, I wasn't having the same problem as you. But after trying some commands in the thread. The problems met me. So I followed the teck advice and now, I think it is running.

Someone can tell me about that ?

mysql> status
--------------
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

Connection id: 8
Current database:
Current user: root@localhost
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 30 min 26 sec

Threads: 1 Questions: 28 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 3
--------------

mysql>


==========================================================================================

[root@www admin]# mysqladmin -p ping
Enter password:
mysqld is alive
[root@www admin]# mysql

==========================================================================================

Does this means that mysql is running on my box ????
It sounds like it is, but I just want to double check before going on with php and phpadmin and etc ...

By the way, I know the newest version is 3.23.32 or above, should I update it before installing php? Or maybe, should I ask, should I really update it?

Mean while, how can I test the mysql without any mysql knowledge? Any command to create the db and test automatically ?

YAHOO~~~~

I installed MySQL and PHP 4.04 successfully.

Thanks for anyone who had helped me in this forum and SitePoints' forum. Anyway, Matt helped me really a lot. :)
Thank you Matt. And Roh@n as well. 100 thank you to all of you :) .