CentOS 6.x MySQL simple configuration

I know that there is many information on the internet about how to install and configure MySQL Server, but I want to have that information on my site also. So let’e begin 🙂

First we have to do the install:

# yum install mysql mysql-server

After that we can run:

# mysql_install_db

then we shall give password for user root in mysql. We can do that in two ways, first:

# /usr/bin/mysqladmin -u root -p ‘secretpass’

second ways is to login into mysql

# mysql -u root

and under mysql shell we should do this:

mysql> set password for ‘root’@’localhost’ = password(‘secretpass’);

And voila – we have done a simple MySQL Server configuration.

Now we have to start the mysqld deamon:

# chkconfig –level 2345 mysqld on
# service mysqld start

That’s all.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

This website stores some user agent data. These data are used to provide a more personalized experience and to track your whereabouts around our website in compliance with the European General Data Protection Regulation. If you decide to opt-out of any future tracking, a cookie will be set up in your browser to remember this choice for one year. I Agree, Deny