Ask Your Question
0

Unable to Configure MySql (MariaDB) to run at startup

asked 2014-02-15 13:33:43 -0600

Jroc gravatar image

updated 2014-02-15 13:40:06 -0600

mether gravatar image

Pulling my hair out... A new install of Fedora 20. Am trying to install the LAMP stack. Four hours now trying to get the database installed, configured and running - all to no avail. Desperately need help. Below is the terminal session.

[jeff@localhost ~]$ su
Password: 

[root@localhost jeff]# systemctl enable mysqld.service
Failed to issue method call: No such file or directory

[root@localhost jeff]# cd /
[root@localhost /]# cd bin
[root@localhost bin]# dir mysql*
mysql                       mysqld_safe           mysql_secure_installation
mysqlaccess                 mysqldump             mysql_setpermission
mysqladmin                  mysqldumpslow         mysqlshow
mysqlbinlog                 mysql_find_rows       mysqlslap
mysqlbug                    mysql_fix_extensions  mysqltest
mysqlcheck                  mysqlhotcopy          mysql_tzinfo_to_sql
mysql_config                mysqlimport           mysql_upgrade
mysql_convert_table_format  mysql_install_db      mysql_waitpid
mysqld_multi                mysql_plugin          mysql_zap

[root@localhost bin]# cd /
[root@localhost /]# cd lib/systemd/system
[root@localhost system]# dir mysqld.*
mysqld.service

[root@localhost system]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service

[root@localhost system]# bin/mysql_secure_installation
bash: bin/mysql_secure_installation: No such file or directory

[root@localhost system]# systemctl status mysqld.service
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
   Active: active (running) since Sat 2014-02-15 14:17:54 EST; 4min 51s ago
  Process: 2118 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 2037 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 2117 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─2117 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─2299 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plug...

Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: The latest infor...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: You can find add...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: http://dev.mysql...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: Support MariaDB ...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: SkySQL Ab. You c...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: Alternatively co...
Feb 15 14:17:52 localhost.localdomain mariadb-prepare-db-dir[2037]: http://mariadb.c...
Feb 15 14:17:52 localhost.localdomain mysqld_safe[2117]: 140215 14:17:52 mysqld_safe...
Feb 15 14:17:52 localhost.localdomain mysqld_safe[2117]: 140215 14:17:52 mysqld_safe...
Feb 15 14:17:54 localhost.localdomain systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

[root@localhost system]#
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2014-02-16 06:00:13 -0600

Please note that also the last one says "mariadb.service", as that is the service file. For backwards compatibility, there is a mysql.service which symlinks there.

As such, to enable it, execute "systemctl enable mariadb.service".

edit flag offensive delete link more

Comments

You are right, that was the answer. I do, of course, feel a bit foolish as I truly didn't notice the 'mariadb.service' right there on the screen in black & white. Perhaps if I had stepped away from my computer instead of staying so focused on the problem for so long - and that mariadb keeps emphasizing that everything works as-if it were MySql. Which, invoking 'mysqld' actually should have worked also, no?

Anyway, thanks so much Patrick for helping me.

Jroc gravatar imageJroc ( 2014-02-16 13:10:55 -0600 )edit

Question Tools

1 follower

Stats

Asked: 2014-02-15 13:33:43 -0600

Seen: 2,641 times

Last updated: Feb 16 '14