NSLU2-Linux
view · edit · print · history

(redirected from Unslung.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

view · edit · print · history · Last edited by Harald Biehl.
Based on work by Harald Biehl, Nigel Walker, ABarends, rwhitby, barrym, and MStolt.
Originally by barrym.
Page last modified on April 08, 2007, at 12:16 AM