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?