MySQL Start "Something went wrong"

English Applications
#1

Hi guys,

I tried to enable/start MySQL for the first time today but got this error message


Doofenshmirtz:~ # systemctl status mysql.service
mysql.service - MySQL server
   Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled)
   Active: active (running) since Wed 2015-04-22 13:06:56 EAT; 5min ago
  Process: 14824 ExecStop=/usr/lib/mysql/rcmysql stop (code=exited, status=0/SUCCESS)
  Process: 14958 ExecStart=/usr/lib/mysql/rcmysql start (code=exited, status=0/SUCCESS)
 Main PID: 15020 (mysqld_safe)
   CGroup: /system.slice/mysql.service
           ├─15020 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/var/lib/mysql
           └─15116 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/Doofenshmirtz.err --pid-file=/var/ru...

Apr 22 13:06:56 Doofenshmirtz rcmysql[14958]: Starting service MySQL Something went wrong

I’m running

NAME=openSUSE
VERSION="13.2 (Harlequin)"
VERSION_ID="13.2"
PRETTY_NAME="openSUSE 13.2 (Harlequin) (x86_64)"
ID=opensuse
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:opensuse:opensuse:13.2"
BUG_REPORT_URL="https://bugs.opensuse.org"
HOME_URL="https://opensuse.org/"
ID_LIKE="suse"

Please help.

#2

It’s enabled and running.

Try: mysqladmin -u root -p status

It’ll ask for your MySQL root password, if you’ve never set it just press enter.

#3

Looks like it is.

Doofenshmirtz:~> mysqladmin -u root -p status
Enter password: 
Uptime: 8567  Threads: 1  Questions: 1  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 63  Queries per second avg: 0.000

Thanks

#4

That “error” message is bogus, see here:
https://bugzilla.opensuse.org/show_bug.cgi?id=914370

#5

Thanks Wolfi!

#6

I have the same “error” and the output is:

webserver162:~ # mysqladmin -u root -p status
Enter password:
Uptime: 686 Threads: 1 Questions: 2 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.002

But I also have Webmin installed, which should normally be able to access mysql to add/edit databases etc, but webmin doesn’t see the MySQL server.

#7

So your mysql server seems to be running fine.
And “systemctl status mysql” should show “active (running)” too, right?

But I also have Webmin installed, which should normally be able to access mysql to add/edit databases etc, but webmin doesn’t see the MySQL server.

I haven’t used Webmin in years.
Maybe you have to configure it/point it to the server it should connect to?

#8

Thank you very much for your reply.
I read on a website that I had to refresh the Webmin modules, that did the trick!

And yes MySQL shows running indeed.