I have finally figured out how to install mysql on Xandros. (Partially thanks to people smarter than me at linuxquestions.org) and the rest thanks to the help on the www.mysql.org page.

To install the software itself, open the Xandros networks application and navigate to

New applications --> Database management

Check both mysql database and mysql navigator.
Either click install selected apps or click the hyperlinks at the bottom of the page that do that same.


Once the software package is installed (the easy part), get around a bug in the initial database setup by doind the following:

locate and run the setup script by doing the following

find / -name mysql_install_db (this will tell you where the script is located)


then run the script. for example on my system

/usr/bin/mysql_install_db

if the script is not executable then make it so using chmod. It should be executable by default.


Next stop the daemons. I did it like this.

ps -A | grep mysql (to locate the process ids)

kill <each process id number here, i had five>
kill < process id number >
kill < process id number >
kill < process id number >
kill < process id number >


Restart the mysql daemon in what I guess to be safe mode

mysqld_safe --skip-grant-tables &


Put a password in for the root user by

mysqladmin -u root flush-privileges password "your password here"


You should be able to log into the mysql command line using

mysql -u root -p (this will ask for password)


Good luck.

I would like to add that the bug that prevents the initial login to the mysql database (the default database) is particular to Xandros and not a problem on MySQL as a whole. I did not mean to imply a general bug in MySQL.

Also, the 'MYSQL Navigator' is a graphical user interface that downloads as well if the full Xandros package for MySQL is installed but it does not generate good sqls unless you log into the database as the owner of that database.