Mysql installation

[baladewa88]

Hi

I want to installed mysql just like in document. I installed mysql using tar.gz file for linux generic (i am using CentOS). I run the tutorial form here : https://dev.mysql.com/doc/refman/5.0/en/binary-installation.html. I already change etc/my.cnf just like the CXM document but when i call "service mysqld start", there's an error message "Redirecting to /bin/systemctl start mysqld.service. Failed to issue method call : Unit mysqld.service failed to load : No such file or directory".

I read form here : https://ask.fedoraproject.org/en/question/43459/how-to-start-mysql-mysql-isnt-starting/, it write that MySQL was replaced by MariaDB. So what i need to do? Should i change to MariaDB? or any other suggestion?

Sorry for my english.

Thanks in advance

[fanchyna]

I should clarify that the script in CiteSeerX code repository is used to create databases and tables therein. It is NOT used to install MySQL daemon. The CiteSeerX MySQL initiation script is independent of the MySQL version. From the link you sent to us, you were trying to install MySQL 5.0 which has been deprecated for a long time. The current stable version is 5.6, which is recommended. MariaDB is just a (giant) branch of MySQL that has been developed by Oracle. Before red hat 6, MySQL is in the default yum repository, but since red hat 7 (or CentOS 7), it is replaced by MariaDB. Your error message indicates that you probably have not installed MySQL.

[baladewa88]

Oke @fanchyna thanks for your respond. i try to yum list installed | grep mysql and i get this message
mysql-community-client.x86_64 5.6.26-2.el7 @mysql56-community
mysql-community-common.x86_64 5.6.26-2.el7 @mysql56-community
mysql-community-libs.x86_64 5.6.26-2.el7 @mysql56-community
mysql-community-release.noarch el7-5 @/mysql-community-release-el7-5.noarch
mysql-community-server.x86_64 5.6.26-2.el7 @mysql56-community

so i though i already install mysql. But when i call "service mysqld start" but i get this message :

Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

i try to install mariaDB but i get this message :

Package 1:mariadb-5.5.44-1.el7_1.x86_64 is obsoleted by mysql-community-client-5.6.26-2.el7.x86_64 which is already installed
Package 1:mariadb-server-5.5.44-1.el7_1.x86_64 is obsoleted by mysql-community-server-5.6.26-2.el7.x86_64 which is already installed
Nothing to do

what i do wrong? Can you point me an advice or clue how to install mysql server in my centos 7?

Thanks in advance

[fanchyna]

The "service" command you were using is obsolete for CentOS 7. Please try the command below:
systemctl start mysqld.service

or

systemctl start mysqld

[baladewa88]

thanks @fanchyna. finally i can install mysql after reinstall via yum. hopefully i will success install citeseer x

Thanks

[baladewa88]

I'ms sorry. today i wan't to start mysql service but after i put systemctl start mysqld.service, i got this message :

Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

I try to systemctl status mysqld.service and i got this message.

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: activating (start-post) since Tue 2015-09-15 10:27:17 WIB; 12min ago
Main PID: 20078 (code=exited, status=0/SUCCESS); : 20079 (mysql-systemd-s)
CGroup: /system.slice/mysqld.service
└─control
├─20079 /bin/bash /usr/bin/mysql-systemd-start post
└─22907 sleep 1

Sep 15 10:27:18 lppm-50.ccar.itb.ac.id mysqld_safe[20078]: 150915 10:27:18 mysqld_safe Logging to '/var/lo...g'.
Sep 15 10:27:18 lppm-50.ccar.itb.ac.id mysqld_safe[20078]: 150915 10:27:18 mysqld_safe Starting mysqld dae...sql
Sep 15 10:27:18 lppm-50.ccar.itb.ac.id mysqld_safe[20078]: rm: cannot remove ‘/var/lib/mysql/mysql.sock�...ied
Sep 15 10:27:18 lppm-50.ccar.itb.ac.id mysqld_safe[20078]: 150915 10:27:18 mysqld_safe mysqld from pid fil...ded

Could you point me where i do wrong? Thanks in advance

[hntd187]

You might not be starting it as root, or mysql might already be running.
Check it first

sudo service mysqld status

Also /var/log/mysqld might have some more information about why it's failing...