Installing mysql can be a bit pain when there are problems in setting up remote access or changing passwords. But it can be easily managed if all the steps are done correctly
Installing Repo
cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo
wget http://rpms.famillecollet.com/enterprise/remi.repo
Installing Mysql
yum –enablerepo=remi install mysql mysql-server mysql-devel php-mysql
Configuring Mysql
Set the MySQL service to start on boot
chkconfig –levels 235 mysqld on
chkconfig –levels 235 mysqld on
Start the MySQL service
service mysqld start
service mysqld start
Log into MySQL
mysql -u rootSet the root user password for all local domainsSET PASSWORD FOR ‘root’@'localhost’ = PASSWORD(‘new-password‘);SET PASSWORD FOR ‘root’@'localhost.localdomain’ = PASSWORD(‘new-password‘);SET PASSWORD FOR ‘root’@’127.0.0.1′ = PASSWORD(‘new-password‘);|
Setting up remote access to database
SET host FOR ‘root’@'localhost’ = ‘%’;
SET host FOR ‘root’@'localhost’ = ‘%’;
Drop the Any user
DROP USER ”@’localhost’;DROP USER ”@’localhost.localdomain’;
Exit MySQLexit
DROP USER ”@’localhost’;DROP USER ”@’localhost.localdomain’;
Exit MySQLexit
alternative way is
mysql -u root
mysql> SET PASSWORD FOR 'ROOT'@'LOCALHOST"
> = PASSWORD('new_password');
Now while we’re still here, we’ll create a new HOST for root and allow root to login from anywhere.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
Disqus comments