Home » Forums » Public Forums » Archived Forums » JumpBox for OTRS Discussion

MySQL Access

Submitted by blang on Mon, 08/25/2008 - 9:39am

I've noticed something in recent JumpBox builds.
The password supplied by this command:
sudo grep password /etc/mysql/debian.cnf
only works when using username: debian-sys-maint.
It will not work if you try to log in to MySQL as root or admin or anything else.

This seems to apply on other JumpBoxes as well as the OTRS one.

‹ Customer.pl appearance URGENT: Backups and Upgrading to a new JumpBox from an old one ›
»

MySQL Access

Submitted by godber on Mon, 08/25/2008 - 11:46am.

I believe you can set the root mysqluser password as the debian-sys-maint user ... but you should be able to do this ...

sudo dpkg-reconfigure mysql-server-5.0

Note: This restarts the mysql server.

Another method:

I am pretty sure as debian-sys-maint:

sudo mysql --defaults-file=/etc/mysql/debian.cnf

the SQL statment

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('biscuit');

will do it.

Austin

»