MySQL - Linux Install MySQL Server on CentOS 6.3 - Configure using mysql_secure_installation

In this tutorial I download and install the mysql server on CentOS 6.3. I also talk about how to then set the root password using the mysql_secure_installation command which is located in the /usr/bin/ directory. We then talk about how to login to the server using the command line, and which switches/arguments are required for the mysql command.

[timothywells]

Huge Thank you for this basic and condensed tutorial. I'll be passing this on to all my classmates that are confused about this course I'm in using MySQL.

[chrishuttonch]

A very clear tutorial, cheers! Very helpful explanations behind your actions.

[jksharma]

Dear Sir, very well Done . Cheers !!! You are the HERO !! Please post how to load data into mysql from a txt file and from oracle table.

[niraspir]

Excellent for beginners. Very helpful, thank you.

[BoYcLuE]

Great turtorials!! Quick question: How can you identify if a MSQL installation was NOT done in a secure installation?

[michaelencarnacion]

straight forward tutorial. Thanks man!

[shameonyou]

All in all a perfect tutorial :D thank you so much !

[murthy]

Thannk you very much. It has helped me a lot. I like your british accent !

[drew]

awesome tutorial, you are very detailed, you know how to teach

[CmlDexter]

Yes thanks for mentioning that running that command to register the password would probably also remain in the history file of centos

[rohitsharma-pzqk]

thanks for the video. specially for secure_installation

[vivrap]

Hi thanks for this great video,
I have been given an assignment on accessing mysql db that is installed on a vm which has ubuntu, from pycharm which is installed on other vm that also has ubuntu. what are the details that i have to give in to connect the database to the pycharm. Thanks in advance.

[waristechtips]

hi 
this video is great. but i have question. i was given an assignment and was asked to have php and httpd in one server and mysql in another. how would i be able to connect these together so that i get the end result? please help! 

[borumint]

how can i make sure that as Mysql database 5.5 version is installed ?

[capetownct]

Awesome. I used this to install via yum and I received an error when trying to start the mysqld service. I had to run the following 3 lines to get the service start:

chown mysql.mysql /var/lib/mysql
chgrp mysql /var/lib/mysql
mysql_install_db --user=mysql --ldata=/var/lib/mysql

I was then able to start the service and continue following the video

[rahulverma]

hi,
I am using linux rhel 6.1. if i install mysql-server via yum command is " yum install mysql-server" but it doesn't install and reply 'no package mysql-server' available.

regards
rahul verma

[SlayerFeast]

awesome tutorial bro. can u pls tell me how do i create a different user with username Shengui and password root