MySQL

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