SlackwareThis Forum is for the discussion of Slackware Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.0.27-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 6
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.0.27-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 3 hours 4 min 36 sec
The socket is there and I altered my php.ini on several lines to point to that location (but maybe that is not even necessary).
Quote:
root@grooves:~# ls -lA /var/lib/mysql/
insgesamt 110628
-rw-rw---- 1 mysql mysql 16384 Sep 30 13:57 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Sep 30 13:57 aria_log_control
-rw-r----- 1 mysql root 1486 Sep 30 14:10 grooves.err
-rw-rw---- 1 mysql mysql 50331648 Sep 30 14:10 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Sep 30 13:57 ib_logfile1
-rw-rw---- 1 mysql mysql 12582912 Sep 30 14:10 ibdata1
-rw-rw---- 1 mysql mysql 0 Sep 30 14:10 multi-master.info
drwx------ 2 mysql root 4096 Sep 30 13:57 mysql/
srwxrwxrwx 1 mysql mysql 0 Sep 30 14:10 mysql.sock=
drwx------ 2 mysql mysql 4096 Sep 30 13:57 performance_schema/
drwx------ 2 mysql root 4096 Sep 30 13:57 test/
Normally, phpmyadmin will just work without additional changes in php.ini
can you post related log messages from /var/log/httpd/access_log and error_log ?
I tried the script posted on stack overflow to see if and where a connection is possible... no luck for localhost, localhost 3306, 127.0.01 and 127.0.0.1.3306
does it expect a mysql socket in that tmp subfolder? There are two files akonadiserver.socket and mysql.socket. Owner is my local user, both with x bit set and they seem accessible since the timestamp is a recent one.
I saw in my hostname.err (/var/lib/mysql/hostname.err) the following line, does iot mean my socket expects connections on port 0? Where can I switch from 0 to 3306 or something else?
Code:
Version: '10.0.27-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 MariaDB Server
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.