Re: MySql Installation problem

[lokesh kumar]

Hi Mohammad,

I need few clarifications like
where u r installing mysql in linux or in windows.

For linux 32 bit
[root@INFCH03298 MySQL-5.5.21]# rpm -i MySQL-server-5.5.16-1.linux2.6.i386.rpm

the above command installs mysql server and

[root@INFCH03298 MySQL-5.5.21]# rpm -i MySQL-client-5.5.16-1.linux2.6.i386.rpm
installs mysql client.

After installation please follow the below steps
[root@INFCH03298 bin]# /usr/bin/mysql_secure_installation this command asks about root password,anonymous users,dropping test database.
Please provide valuable inputs there.

Then connect to mysql server with the below command.

[root@INFCH03298 bin]# /usr/bin/mysqladmin -u root

Then start the server with the below command
[root@INFCH03298 /]# /etc/init.d/mysql start

****************************************************
If Server is not starting
and getting the below mentioned error message means
****************************************************

MySQL manager or server PID file could not be found!
Article Number: 19 | Rating: Unrated | Last Updated: Tue, Oct 25, 2011 at 5:11 PM
Problem - You get these types of errors when you restart mysql
MySQL manager or server PID file could not be found! [FAILED]
ERROR! MySQL manager or server PID file could not be found!
/etc/init.d/mysql: /usr/local/bin/hostname: not found

[root@INFCH03298 tmp]# touch mysql.sock
[root@INFCH03298 tmp]# chown -R mysql:mysql mysql.sock
[root@INFCH03298 tmp]# which mysql
/usr/bin/mysql
[root@INFCH03298 /]# /etc/init.d/mysql start
Starting MySQL.. SUCCESS!

*******************************************
Connecting to MySQL through command prompt
*******************************************
[root@INFCH03298 /]# mysql --user=root --password=root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.5.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>