Author: Steven Neiland
Published:

Warning: This blog entry was written two or more years ago. Therefore, it may contain broken links, out-dated or misleading content, or information that is just plain wrong. Please read on with caution.

Step 4: Enable Networking

If you are planning to use tcp/ip to connect to the database(s) we must make a few changes to enable networking.

Edit "/etc/my.cfn" and comment out the line that says "skip networking". Also open "/etc/rc.d/rc.mysqld" and comment out the "skip-networking" line there.

Step 5: Start MySQL

At this stage we can start MySQL with the following command.

# /etc/rc.d/rc.mysql start

Step 6: Set Root MySQL User Password

Now that MySQL is running we need to lock down the root account by setting its password.

# mysqladmin -u root password '[new-password]'

Step 7: Connect to MySQL

To ensure that our password is working, try to connect as root.

# mysql -u root -p
1 2 3

What Do You Think?

Reader Comments

Post a Comment

Comment Etiquette:

  • Please keep comments on-topic.
  • Please do not post unrelated questions or large chunks of code.
  • Please do not engage in flaming/abusive behaviour.
  • Comments that contain or appear to be advertisments, will not be published.
  • Comments that appear to be created for the purpose of linkbuilding to commercial sites will be removed.

We are all adults here so play nice.

*
*



Archives Blog Listing

Tag Listing

Learn CF In A Week

Treehouse

 
Fork me on GitHub