Ticket Options
Question Details
TICKET ARCHIVE -> Mysql
MarcovandenOever - Jul 19, 2005 - 4:48 am
I've installed MySQL and the neccesary PHP tools. When I want to connect to MYSQl through my browser --> http://localhost/phpmyadmin. I get a message wich begins with "Welcome to phpMyAdmin 2.6.3-pl1" an then an error: "MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
In my system preferences the MySQL Server Status is "Stopped', but it can't be started with the "Start MySQL Server"-button.
Is there something I do wrong?
Marco
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
In my system preferences the MySQL Server Status is "Stopped', but it can't be started with the "Start MySQL Server"-button.
Is there something I do wrong?
Marco
ged3000 - Jul 21, 2005 - 3:35 am
Hi!
When I upgraded to my current machine, I had very similar problems. The MySQL system preference didnt seem to want to do anything for me either.
How competent are you with the terminal? You can start MySQL with the following command (in the terminal):
$ cd /usr/local/mysql
$ ./bin/safe_mysqld --user=mysql &
(This assumes that you installed MySQL in /usr/local/mysql - if you installed it somewhere else, change the path in the first line to wherever you installed mysql)
This might not work - I know that for me, this quit out saying that it didnt have permissions to access some files. If this happens to you, try the following instead:
$ sudo -s
(type your login password)
$ cd /usr/local/mysql
$ ./bin/safe_mysqld --user=mysql &
Unfortunatly, this only opens MySQL until you restart. If you want to make it start automatically, then you could try instaling the MySQL Startup Item Package, which should be included with the install application for MySQL that you downlaoded from www.mysql.com .
Hope that helps,
Ged Manning
When I upgraded to my current machine, I had very similar problems. The MySQL system preference didnt seem to want to do anything for me either.
How competent are you with the terminal? You can start MySQL with the following command (in the terminal):
$ cd /usr/local/mysql
$ ./bin/safe_mysqld --user=mysql &
(This assumes that you installed MySQL in /usr/local/mysql - if you installed it somewhere else, change the path in the first line to wherever you installed mysql)
This might not work - I know that for me, this quit out saying that it didnt have permissions to access some files. If this happens to you, try the following instead:
$ sudo -s
(type your login password)
$ cd /usr/local/mysql
$ ./bin/safe_mysqld --user=mysql &
Unfortunatly, this only opens MySQL until you restart. If you want to make it start automatically, then you could try instaling the MySQL Startup Item Package, which should be included with the install application for MySQL that you downlaoded from www.mysql.com .
Hope that helps,
Ged Manning
MarcovandenOever - Jul 21, 2005 - 4:33 am
Thanks for your reply. I;ve downloaded de MAMP installer from http://www.mamp.info/en/home/. and with this i'm able to create MySQL Databases. The MySQL Server Status is still stopped? Strange but true
ged3000 - Jul 21, 2005 - 4:38 am
That looks like a cool download - I might make use of that sometime!
As far as the MySQL controlpanel goes - ive kinda given up on it. It doesnt seem to be at all reliable at telling you if your mysql server is working...
Is phpmyadmin working now?
Ged Manning
As far as the MySQL controlpanel goes - ive kinda given up on it. It doesnt seem to be at all reliable at telling you if your mysql server is working...
Is phpmyadmin working now?
Ged Manning
MarcovandenOever - Jul 21, 2005 - 4:47 am
As far as I can see.. yes. But, I'm just a rookie on php. I'm folowing the 'learning php' on lynda.com and needed to install MySQL, PHPmyAmdin, Apache. These are all included in the earlier mentioned MAMP installer
ged3000 - Jul 21, 2005 - 4:55 am
OK - thats great news!
When I was learning php/mysql, i found the php website really useful - its got a very comprehensive list of commands - www.php.net - you can search for a command and it gives you an information page on it.
Ill close this question and let you get on with your programming! Have fun and good luck! (Dont heasitate to ask again if you come across any more problems!)
Ged Manning
When I was learning php/mysql, i found the php website really useful - its got a very comprehensive list of commands - www.php.net - you can search for a command and it gives you an information page on it.
Ill close this question and let you get on with your programming! Have fun and good luck! (Dont heasitate to ask again if you come across any more problems!)
Ged Manning
IF THIS IS YOUR QUESTION AND YOU WISH TO RESPOND, LOGIN HERE FIRST.
