Jump to content
  • 0
Sign in to follow this  
xeNium

rAthena on CentOS platform.

Question

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

 

[[email protected] ~]# /etc/init.d/mysqld start
bash: /etc/init.d/mysqld: No such file or directory
 
[[email protected] ~]# service mysql start
failed to start mysql.service unit mysql.service failed to load no such file or directory
 
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?

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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 by yepp

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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.

 

 

Share this post


Link to post
Share on other sites
  • 0

looks like you didnt install it.

 

run the following

 

mysql --version

 

if it returns the version run

 

locate mysql

 

to see where it is.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.