Monday, August 5, 2013

How to install and configure MySQL Database & phpmyadmin

How to install and login 

# Yum  -y install mysql-server mysql
#/etc/rc.d/init.d/mysqld restart
#chkconfig mysqld on

Login command

#mysql -u root –p

How to install phpMyAdmin

#yum --enablerepo=epel -y install phpMyAdmin php-mysql php-mcrypt
#vim /etc/httpd/conf.d/phpMyAdmin.conf
Allow from all
#/etc/rc.d/init.d/httpd reload
#/etc/rc.d/init.d/httpd restart
#vim /etc/php.ini
post_max_size = 100M
upload_max_filesize = 100M

Command

Set password command on mysql root user
# mysqladmin -u root password NEWPASSWORD
Change password on mysql root & user
# mysqladmin -u root –p oldpassword password newpass

0 comments: