The step by step procedure below is show the setup procedure and the configuration of MYSQL database server (MSQLd) on Fedora Core 6 operating system.

[root@tenouk ~]# mysqladmin -u dba_user -p create databasename
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

1. If the error message above appear, this could mean that you MYSQL sever is not in service, you need to start the mysqd server on your fedora core server. Try the service command to start mysqld as in example below:.

[root@tenouk ~]# service mysqld start
Initializing MySQL database: Neither host 'tenouk.jmti.gov.my' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
[FAILED]
2. If the error above appear, these mean that the hosts file is not configure properly. If the same error happen, use the step below to configure your server hosts file: If NOT proceed to step 3.

[root@tenouk ~]# gedit /etc/hosts

examples of hosts file:
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 tenouk.jmti.gov.my tenouk localhost.localdomain localhost

Then after you save the file, try ping your network to check and verify the configuration changes.
[root@tenouk ~]# ping 127.0.0.1
[root@tenouk ~]# ping tenouk
[root@tenouk ~]# ping tenouk.jmti.gov.my

3. To start MYSQL sever issue the command below:
[root@tenouk ~]# service mysqld start
Initializing MySQL database: Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h tenouk.jmti.gov.my password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[ OK ]
Starting MySQL: [ OK ]
[root@tenouk ~]#

5. Now create root password for you MYSQLd (MYSQL database server)
[root@tenouk ~]# mysqladmin -u root password 'new-password'