Cannot Get MySQL to work

Help and Support Raspberry Pi
1

I’ve followed the instructions to the letter but when I go to change the ip address in the conf file it goes to a big black screen that says this along the bottom:

directory ‘/ect/mysql/mariadb.conf.d’ does not exist

What am I doing wrong?

2

Well, you could give us a bit more information:

  • what instructions are you referring to?
  • which conf file are you referring to?
  • is the error you list a copy/paste or did you mistype it?

Please also provide full logs: run grab-logs -A and let us know the URL it returns.

1 Like
3

I was reading the MySQL instructions in the How To thread and followed kyblick’s post, the most recent one in the thread. The step I’m having trouble with is the last one where the IP address is replaced with 0’s. I will try to post a log when I have a chance. We have no dedicated internet connection so everything is depending on hotspoting my wife’s iPhone.

4

Hi,

Please provide the output of the following command:

ls /etc/mysql/

Thanks Tom.

P.S

Dilthedog has just noticed a typo in your post:

I think the command you want is this:

its not ect its etc.

Thanks Tom.

5

I’ve gone through kyblick’s post and have encountered no problems:

osmc@osmc:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree        
Reading state information... Done
The following additional packages will be installed:
  default-mysql-server galera-3 gawk libdbi-perl libjemalloc1 libreadline5 lsof mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common
  mariadb-server-10.1 mariadb-server-core-10.1 rsync socat
Suggested packages:
  gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl mailx mariadb-test netcat-openbsd tinyca
Recommended packages:
  libdbd-mysql-perl libterm-readkey-perl libhtml-template-perl
The following NEW packages will be installed:
  default-mysql-server galera-3 gawk libdbi-perl libjemalloc1 libreadline5 lsof mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common
  mariadb-server-10.1 mariadb-server-core-10.1 mysql-server rsync socat
0 upgraded, 15 newly installed, 0 to remove and 2 not upgraded.
Need to get 22.6 MB of archives.
After this operation, 153 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
<snip a load of download/setup messages>
osmc@osmc:~$ sudo mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create user 'osmc' identified by 'osmc';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all on *.* to 'osmc';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> quit
Bye
osmc@osmc:~$ sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
osmc@osmc:~$ sudo systemctl restart mysql
osmc@osmc:~$ sudo systemctl status mysql
● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Sat 2018-05-05 21:07:47 BST; 6s ago
  Process: 23291 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 23289 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 23173 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl se
  Process: 23168 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 23165 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 23262 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─23262 /usr/sbin/mysqld

May 05 21:07:42 osmc systemd[1]: Starting MariaDB database server...
May 05 21:07:45 osmc mysqld[23262]: 2018-05-05 21:07:45 1990123520 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 23262
May 05 21:07:47 osmc systemd[1]: Started MariaDB database server.

Do you get the message when you restart mysql?

9

It was indeed the ect vs etc typo. Good eye and thank you for your patience everyone.

1 Like
10

Just one more update. I have the whole set-up finished and it works flawlessly. Thank you to everyone who responded. I actually learned quite a bit and feel more comfortable working from the command line.

1 Like
11

Great news!