NSLU2-Linux
view · edit · print · history

Optware.MySQL History

Hide minor edits - Show changes to markup

April 08, 2007, at 12:16 AM by Harald Biehl -- Changed ln -s ln -s /opt/lib/mysql/libmysqlclient.so /lib/libmysqlclient.so.14
Changed lines 54-55 from:
  1. ln -s /opt/lib/mysql/libmysqlclient.so /opt/lib/libmysqlclient.so.14
to:
  1. ln -s /opt/lib/mysql/libmysqlclient.so /lib/libmysqlclient.so.14
April 06, 2007, at 10:37 AM by Harald Biehl -- Changed ln -s ln -s /opt/lib/mysql/libmysqlclient.so /lib/libmysqlclient.so.14
Changed lines 54-55 from:
  1. ln -s /opt/lib/mysql/libmysqlclient.so /lib/libmysqlclient.so.14
to:
  1. ln -s /opt/lib/mysql/libmysqlclient.so /opt/lib/libmysqlclient.so.14
January 13, 2007, at 09:32 AM by Nigel Walker -- Missing symlink in MySQL
Changed lines 45-56 from:
to:

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

January 20, 2006, at 10:42 AM by ABarends --
Changed lines 9-10 from:
  1. mysql -u root
to:
  1. /opt/bin/mysql -u root
August 16, 2005, at 01:14 PM by rwhitby -- Remove the .mysql_history file, cause it holds your password in the clear.
Added lines 26-27:
  1. rm -f ~/.mysql_history
May 24, 2005, at 05:59 PM by barrym --
Changed lines 5-11 from:
  1. /opt/bin/mysqld_safe --skip-grant-tables &
  2. mysql -u root
  3. mysql> use mysql;
  4. mysql> update user set Password = PASSWORD('pass') where User ='root';\\
to:
  1. /opt/bin/mysqld_safe --skip-grant-tables
  2. Start a new terminal window
    1. mysql -u root
    2. mysql> use mysql;
    3. mysql> update user set Password = PASSWORD('pass') where User ='root';\\
Changed line 19 from:
  1. mysql> exit\\
to:
  1. mysql> exit\\
Changed lines 24-25 from:
  1. /opt/etc/init.d/S70mysqld stop
to:
  1. /opt/etc/init.d/S70mysqld stop
May 23, 2005, at 12:52 AM by MStolt -- Adding remote access
Changed lines 24-41 from:
  1. /opt/etc/init.d/S70mysqld start
to:
  1. /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.

May 23, 2005, at 12:46 AM by MStolt --
Changed lines 5-6 from:
  1. /opt/bin/mysqld_safe --skip-grant-tables
to:
  1. /opt/bin/mysqld_safe --skip-grant-tables &
May 15, 2005, at 05:19 PM by barrym --
Added lines 1-24:

To Reset MySQL Root Password

  1. /opt/etc/init.d/S70mysqld stop
  2. /opt/bin/mysqld_safe --skip-grant-tables
  3. mysql -u root
  4. mysql> use mysql;
  5. 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

  6. mysql> exit

    Bye

  7. /opt/etc/init.d/S70mysqld stop
  8. /opt/etc/init.d/S70mysqld start
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