Author: Steven Neiland

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


Fork me on GitHub