29-04-2013, 19:08
Witam. Mam problem z połączeniem z bazą. Z tego co zauważyłem problem często spotykany, jednak pomimo szczerych chęci nie potrafiłem sobie z nim poradzić. Problem mam na komputerze w pracy dlatego nie za bardzo wiem jakie tam cuda były robione.
zawartość my.cnf:
error.log:
Jakieś praktyczne rady mile widziane.
Kod:
~$ sudo service mysql start
mysql start/running, process 12074
Kod:
~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
zawartość my.cnf:
Kod:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
#/tmp/mysqld.sock
[mysqld_safe]
socket = /var/lib/mysql/mysql.sock
nice = 0
#/tmp/mysqld.sock
user = mysql
socket = /var/lib/mysql/mysql.sock
port = 3306
#basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
error.log:
Kod:
130429 14:16:51 [Note] Plugin 'FEDERATED' is disabled.
130429 14:16:51 InnoDB: The InnoDB memory heap is disabled
130429 14:16:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130429 14:16:51 InnoDB: Compressed tables use zlib 1.2.7
130429 14:16:51 InnoDB: Using Linux native AIO
130429 14:16:51 InnoDB: Initializing buffer pool, size = 128.0M
130429 14:16:51 InnoDB: Completed initialization of buffer pool
130429 14:16:51 InnoDB: highest supported file format is Barracuda.
130429 14:16:51 InnoDB: Waiting for the background threads to start
130429 14:16:52 InnoDB: 5.5.31 started; log sequence number 12572707403
130429 14:16:52 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130429 14:16:52 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130429 14:16:52 [Note] Server socket created on IP: '127.0.0.1'.
130429 14:16:52 [Note] Event Scheduler: Loaded 0 events
130429 14:16:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31-0ubuntu0.12.10.1' socket: '/var/lib/mysql/mysql.sock' port: 3306 (Ubuntu)
Jakieś praktyczne rady mile widziane.