rAthena on CentOS platform.

[xeNium]

I've read both rAthena and Hercules tutorials about Installation on CentOS platform, but I am struggling to start MySQL service.

 

[root@localhost ~]# /etc/init.d/mysqld start

bash: /etc/init.d/mysqld: No such file or directory

 

[root@localhost ~]# service mysql start

failed to start mysql.service unit mysql.service failed to load no such file or directory

 

[root@localhost ~]# mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

I also have installed MariaDB, and it does work, unfortunately I don't know how to use it.

 

Do you have up-to-date tutorial for CentOS 7 platform?

[yepp]

MariaDB is a fork of MySql so it is 99% compatible and it is much better. Everything else is the same.

 

mysql -u(username) -p(password) (databasename) or

 

mysql -p

 

Like that. No difference. I also have CentOS in my server and I love its stability.

 

--EDIT--

 

Oh to answer your question, I see that you are using CentOS 7.

 

Try this:

 

sudo systemctl start mariadb

 

To check if it's installed:

 

rpm -qa | grep mariadb

 

In case mariadb-server is not installed:

 

sudo yum install mariadb-server

Edited June 11, 2016 by yepp

[Neffletics]

Hmmm... better reinstall your OS and follow the guide again.

I just followed the guide before (2 years ago, I think) and it worked fine.

[HaARiZz]

Hi there,
Probably there have something wrong with your MySQL.
You can try to completely remove and reinstall MySQL in your VPS.

You can try to follow this step for reinstall your MySQL :

 

 

Step 1: Uninstall MySQL Packages

First uninstall all the MySQL packages installed on your server

 # yum remove mysql mysql-server

 

Step 2: Remove MySQL Directory

Now we need to remove MySQL data directory from system which by default exists at /var/lib/mysql. If you didn’t find this, It may be changed to some other place, which you can find in my.cnf file with variable datadir. Delete the /var/lib/mysql directory from system but we prefer to rename it to keep a backup of existing files.

 # mv /var/lib/mysql /var/lib/mysql_old_backup

 

Step 3: Install MySQL Packages Again

After removing MySQL completely, install it again using yum package manager, It will re create mysql directory under /var/lib/.

# yum install mysql mysql-server

After completing above three steps, now you have a fresh MySQL install on your system with new settings.

You can now refer to this wiki for reconfigure MySQL for your server.

https://rathena.org/wiki/Installation_(CentOS)

 

 

[Spre]

looks like you didnt install it.

 

run the following

 

mysql --version

 

if it returns the version run

 

locate mysql

 

to see where it is.