[SOLVED] how to start built-in mysql in centos6.4.

rahulvishwakarma · 09-03-2014, 06:14 AM

hi to all,
I'm new in mysql database. I checked mysql already installed (or shipped) with centos6.4 as follows :-

Code:

[root@kaljayi rahul]# rpm -qa mysql-server
mysql-server-5.1.66-2.el6_3.x86_64
[root@kaljayi rahul]# rpm -qa mysql-client
[root@kaljayi rahul]# rpm -qa mysql
mysql-5.1.66-2.el6_3.x86_64

But I don't know how to start or configure (if it starts with startup of operating system) it. Help me to how to start and configure mysql. I also installed mysql-workbentch-5.2.31, but don't know how to work with this.

alexsdba · 09-03-2014, 09:50 AM

Check if MySQL is already running:

Code:

service mysqld status

Start MySQL:

Code:

service mysqld start

Log into MySQL:

Code:

mysql -u root -p -h 127.0.0.1

Doug G · 09-03-2014, 06:28 PM

You should run mysql_secure_installation script after you get mysql started.

rahulvishwakarma · 09-03-2014, 10:19 PM

Thank you very much for your reply. I did it like you said and found solution :-

Code:

[root@kaljayi rahul]# service mysqld start
[root@kaljayi rahul]# chkconfig mysqld on

[root@kaljayi rahul]# mysql_secure_installation