Symlink issue: ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock Password cahnge for pkgmaster mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD +++++++++++++++ lost password for Cobalt +++++++++++++ $ su - # /etc/rc.d/init.d/mysqld stop # /usr/bin/mysqld_safe --datadir=/var/lib/mysql --skip-grant-tables & # mysql -u root mysql mysql> update user set Password=PASSWORD('newpwd') where User='root'; mysql> quit # /etc/rc.d/init.d/mysqld stop # /etc/rc.d/init.d/mysqld start ++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++ lost password for CBQ +++++++++++++ $ su - # /etc/init.d/mysqld stop # /usr/bin/mysqld_safe --datadir=/var/lib/mysql --skip-grant-tables & # mysql -u root mysql mysql> update user set Password=PASSWORD('newpwd') where User='root'; mysql> quit # /etc/init.d/mysqld stop # /etc/init.d/mysqld start ++++++++++++++++++++++++++++++++++++++++++++++++++ # Example Create a database CREATE DATABASE ; GRANT USAGE ON * . * TO ''@'%' IDENTIFIED BY '' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; GRANT ALL PRIVILEGES ON `` . * TO 'username'@'%' WITH GRANT OPTION ; FLUSH PRIVILEGES; # Example "import a dump file" mysql -u -p -h localhost < ###