I installed MySQL in my openSUSE 12.3 with zypper; but when I started it, I got errors below:
root@suse:~ # service mysql start
Failed to issue method call: Unit mysql.service failed to load: No such file or directory. See system logs and 'systemctl status mysql.service' for details.
and this:
~ $ systemctl status mysql.servicemysql.service
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
also:
~ $ sudo systemctl enable mysql.service
mysql.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig mysql on
MySQL still has a sysv-style init script, so there is no mysql.service.
Try to start it with “sudo systemctl start mysql”.
To get the status, run “systemctl status mysql”.
And to enable it on boot, run “sudo systemctl enable mysql” (although you seem to have it enabled already)
And you can omit the “.service” in general, btw. systemctl will automatically add it if needed.
Welcome to the forums. As this is your first post, I suggest, if you have not already done it, that you go into YaST>System services and check that mysqld is enabled. Then open a terminal and enter
mysql_secure_installation
In answer to the password question, give a secure root password and accept the defaults for everything else.
After you have done all this, come back if you have any problems.
~ $ systemctl status mysql.servicemysql.service
Loaded: error (Reason: No such file or directory)
Active: inactive (dead)
QUOTE]
If this is the exact command, it won’t work(You’ve posted a command with mysql.service twice. You also don’t need to type the suffix “.service” systemd will automatically append it unless you have multiple entries). You need to post the results of
systemctl status mysql
That should return some important info, there may also be info in your system logs, eg
cat /var/log/messages | grep mysql
To this point, there isn’t enough information to know what the issue is, but IMO
It’s unlikely you have an authentication problem starting the service
It’s unlikely MySQL (or MariaDB) was installed incorrectly and can’t start
If this is the exact command, it won’t work(You’ve posted a command with mysql.service twice.[/QUOTE]
That was the original poster, and that was posted nearly a year ago.
