Details
Major
Description
I have been trying to install mariadb 5.4.20 since I can remember, it actually makes me feel if anyone has installed it yet on centos from build.
Anyway, I followed these steps,
https://gist.github.com/samayo/305ef8a08a4a4ec9f9c7
and here the error that keeps appearing.
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I can't find mysql.sock file anywhere in my virtualbox.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Well, this error is natural, you really don't appear to have an CXX compiler on the machine. Install it.
Please also note that currently your mariadb-5.5.40/CMakeLists.txt file is empty – I don't know how you achieved this, but make sure you've created a new source dir before you try again (after you've installed the compiler and whatever else is necessary to actually build the server).
Please comment when you reach the point of the original mysql_install_db problem.
Here is what I have when I ssh to your machine, cd to the same dir and run the same command (but typed manually in the command line):
[root@kylix ~]# cd /usr/local/mariadb/scripts/ [root@kylix scripts]# ./mysql_install_db --basedir=/usr/local/mariadb --datadir=/usr/local/mariadb/data Installing MariaDB/MySQL system tables in '/usr/local/mariadb/data' ... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/local/mariadb/bin/mysqladmin' -u root password 'new-password' '/usr/local/mariadb/bin/mysqladmin' -u root -h kylix password 'new-password' Alternatively you can run: '/usr/local/mariadb/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. You can start the MariaDB daemon with: cd '/usr/local/mariadb' ; /usr/local/mariadb/bin/mysqld_safe --datadir='/usr/local/mariadb/data' You can test the MariaDB daemon with mysql-test-run.pl cd '/usr/local/mariadb/mysql-test' ; perl mysql-test-run.pl Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Support MariaDB development by buying support/new features from SkySQL Ab. You can contact us about this at sales@skysql.com. Alternatively consider joining our community based development effort: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
The reason why you are getting the error is that you are still not using double-hyphens. Here is what I see in the history:
154 cd /usr/local/mariadb/scripts 155 ./mysql_install_db -–basedir=/usr/local/mariadb -–datadir=/usr/local/mariadb/data 156 exit 157 cd /usr/local/mariadb/scripts/ 158 ./mysql_install_db --basedir=/usr/local/mariadb --datadir=/usr/local/mariadb/data
154-156 are your commands. 157-158 are mine. Do you see the difference between 155 and 158?
its hard to make any sense out of this, but it worked!!!
I have dealt with mis-typed errors before, but this one takes the cookie.
anyway, thank you so much and sorry for killing your time with my retarded question. <3
You are welcome.
Please change the password if you haven't done it yet. I made your comment with it private, but it went public initially, which is no good even for a test box.
And you can remove my ssh key now since the problem has been resolved.
No worries, But I destroyed to entire vps, that is my definition of security, if & when I share sensitive data 
thanks again && cheers
Hi,
What is MariaDB 5.4.20?
In the paste you apparently skipped some steps, but it's impossible to say how many and which, so proper diagnostics is impossible.
You don't create mysql user, but I don't see any mention of complaints about it missing. Do you already have it?
Right after make install you run mysql_install_db from the current datadir. There will be no mysql_install_db in the current datadir, so apparently something else happened between the two commands. What was it?
You don't install the service, but somehow it exists at the moment you run it.Where did you get it?
Which user are you running all the commands from, root?
Where do you see the message about the missing socket?
Is the mysqld process running?