[Solved] Problem with Mysql on Ubuntu server
Posted: Sun Jul 18, 2010 6:30 pm
I'm not sure this is the right place to start this topic, but since here is the guide for setting up the server, it seemed the right place to put it...
Anyway the issue:
I installed the LAMPP like the wiki suggested, but when I tried to run the database installer I got an error saying that mysql was an unknown command or smthng, so I downloaded the mysql-server and mysql-client (via apt-get install).
After that when I tried to execute the installer it give me the error: 'Can't connect to local Mysql server through socket '/var/run/mysqld/mysqld.sock'.
After a lot of googling and a moment of clarity, I realized that it was because lampp Mysql and MySql conflict, so I stopped Lampp and started the 'pure' MySQL.
Trying to install the database with 'pure' Mysql seems to have worked, but I cannot connect to it remotely (navicat or phpMyadmin), so I'm not quite sure... (I have granted all access rights for all the table to root@my-ip through mysql commands, but it didn't help at all...)
So, what should I do now? Should I try to fix the problems of pure Mysql and have lampp only for the websites? Should I try to remove 'pure' MySQL and try to work with the lampp issues? And how?
Anyway the issue:
I installed the LAMPP like the wiki suggested, but when I tried to run the database installer I got an error saying that mysql was an unknown command or smthng, so I downloaded the mysql-server and mysql-client (via apt-get install).
After that when I tried to execute the installer it give me the error: 'Can't connect to local Mysql server through socket '/var/run/mysqld/mysqld.sock'.
After a lot of googling and a moment of clarity, I realized that it was because lampp Mysql and MySql conflict, so I stopped Lampp and started the 'pure' MySQL.
Trying to install the database with 'pure' Mysql seems to have worked, but I cannot connect to it remotely (navicat or phpMyadmin), so I'm not quite sure... (I have granted all access rights for all the table to root@my-ip through mysql commands, but it didn't help at all...)
So, what should I do now? Should I try to fix the problems of pure Mysql and have lampp only for the websites? Should I try to remove 'pure' MySQL and try to work with the lampp issues? And how?