MG's Notes

problem:

./load ezmlm-gate subdb.a getconf.o slurpclose.o slurp.o \
getopt.a getln.a auto_bin.o env.a sig.a fs.a \
strerr.a substdio.a stralloc.a alloc.a error.a str.a case.a wait.a \
open.a lock.a seek.a -L/usr/lib64/mysql -lmysqlclient -lnsl -lm -lz
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [ezmlm-gate] Error 1
error: Bad exit status from /var/tmp/rpm-tmp.578TXA (%build)

check if you have:

 /usr/lib64/mysql

if not, make a link :

 ln -s /usr/lib/mysql/ /usr/lib64/

 in /usr/lib/mysql/  you must have something like this:

 libmysqlclient.a
 libmysqlclient_r.a
 libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0
 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
 libmysqlclient_r.so.16.0.0
 libmysqlclient.so -> libmysqlclient.so.16.0.0
 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
 libmysqlclient.so.16.0.0

written by MG \\ tags: bash, Linux, MySql, qmail

Go to a mysql client, select you database and run:

UPDATE `cpg_users` SET `user_password` = MD5( ‘new_password_here‘ ) WHERE `user_name` = “username“;

“new_password_here” – replace this with the new password you wish to use.
“username” – replace this with the username the password should be updated for.

written by MG \\ tags: coppermine, MySql

#!/bin/bash
#destination directory named with daily date
DIR=”/var/backup/mysql/$(date +%m%d%Y)”
if [ -d $DIR ]; then
    echo “Dir $DIR exists”;
else
    echo “Creating $DIR”;
    mkdir $DIR
fi

USER=”root”
ROOT_PASSWORD=”root_password”

#get list of databases
LIST=`mysql -u $USER -p$ROOT_PASSWORD -e”show databases” -s |egrep -v ‘Database|information_schema|mysql|temp’`

Continue reading »

written by MG \\ tags: backup, Linux, MySql

• 1. Stop the mysqld daemon process.
• 2. Start the mysqld daemon process with the –skip-grant-tables option.
• 3. Start the mysql client with the -u root option.
• 4. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
• 5. Execute the FLUSH PRIVILEGES; command.

These steps reset the password for the “root” account to “password”. To change the password for a different account, or to set a different password, just edit the variables in single-quotes in step 4.

If you know your existing MySQL root password, steps 1-3 are not necessary.

written by MG \\ tags: Linux, MySql, password