To Reset MySQL Root Password

1. /opt/etc/init.d/S70mysqld stop
2. /opt/bin/mysqld_safe --skip-grant-tables
3. Start a new terminal window
   1. /opt/bin/mysql -u root
   2. mysql> use mysql;
   3. mysql> update user set Password = PASSWORD('pass') where User ='root';
      
      Query OK, 2 rows affected (0.02 sec)
Rows matched: 2 Changed: 2 Warnings: 0
      
      
   4. mysql> exit
      
      Bye
      
      
   5. /opt/etc/init.d/S70mysqld stop
   6. rm -f ~/.mysql_history
4. /opt/etc/init.d/S70mysqld start

To enable remote access with mysqladmin or mysqlquery

Edit the configuration file for mysql

/opt/etc/my.cnf

comment the line skip-networking with an # in front of skip-networking

stop and restart the server

1. /opt/etc/init.d/S70mysqld stop
2. /opt/etc/init.d/S70mysqld start

connect with your client from remote.

To correct symlink error in MySQL

symptom :-

mysqladmin: error while loading shared library libmysqlclient.so.14: cannot open shared object file: No such file or directory

treatment :-

As root, create the following link:

1. ln -s /opt/lib/mysql/libmysqlclient.so /lib/libmysqlclient.so.14

Thanks to Ovidiu Sas for this solution