I just created a new Centos VPS and then followed the LAMP setup tutorial.
I now want to install Wordpress via SSH (I dont want to do the one click installation process)and I need to login to Mysql to create a new db but when I run this:
mysql -u root -p
and then hit enter to enter a blank password I get this:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
so then I try it again but I enter my root password and it returns this:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
also tried running this:
service mysqld start
Failed to start mysqld.service: Unit not found.
what do I need to do here?
edit: this is with MariaDB btw
and some more info:
sudo systemctl status mariadb.service
says its enabled and running:
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2017-03-29 13:52:43 +07; 2 days ago
sudo rpm -q mariadb-server
yum list installed | grep mariadb
mariadb-server.x86_64 1:5.5.52-1.el7 @base
and finally when I try running this:
I get this
touch: cannot touch ‘.my.cnf.23570’: Permission denied touch: cannot touch ‘.mysql.23570’: Permission denied chmod: cannot access ‘.my.cnf.23570’: Permission denied chmod: cannot access ‘.mysql.23570’: Permission denied NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): /usr/bin/mysql_secure_installation: line 232: .my.cnf.23570: Permission denied /usr/bin/mysql_secure_installation: line 233: .my.cnf.23570: Permission denied /usr/bin/mysql_secure_installation: line 234: .my.cnf.23570: Permission denied /usr/bin/mysql_secure_installation: line 236: .my.cnf.23570: Permission denied /usr/bin/mysql_secure_installation: line 205: .mysql.23570: Permission denied /usr/bin/mysql_secure_installation: line 207: .mysql.23570: Permission denied
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!