I have downloaded and unpacked MySQL 5.6.12 to /opt/mysql/server-5.6
. I want to use this db instead of pre-installed 5.5 version. But neither version works.
When I want to start a server with mysqld --console
(pre-installed version) I get this error:
user@user-desktop:~$ sudo mysqld --console
[sudo] password for user:
130719 19:26:17 [Warning] Can't create test file /var/lib/mysql/user-desktop.lower-test
130719 19:26:17 [Warning] Can't create test file /var/lib/mysql/user-desktop.lower-test
mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
130719 19:26:17 [ERROR] Aborting
130719 19:26:17 [Note] mysqld: Shutdown complete
There are no any of these dirs in my system:
/var/lib/mysql/
/var/lib/mysql/
/var/lib/mysql/
How can it be? MySQL is pre-installed but dirs are absent. Should I create them manually? Or do I need to do smth else, run some program, to create them? What mode do I need to set for them?
There is some mysql_install_db
program in the system. Should I run it to set up MySQL?