HOWTO Start MySQL Navigator

By Jan Pihlgren <jan@pihlgren.se> (2002-05-26)

The program is made by Shi Bok Jang <sise15@mizi.com>

I have only tried to do a small instruction howto start the navigator because I get som trubble when I tried to start it. And I get a lot of help from Shi Bok Jang (very fast respons) so most of the facts is comming from Shi Bok Jang.

Thanks Shi Bok Jang.

1.Start MySQL

ex)

su

cd /usr/local/mysql

bin/safe_mysqld &

2.find mysql.sock

ex)

# find /-name mysql.sock

3.if you find mysqlsock in /tmp directory link it to /tmp/kde-mysql/ksycoca

ex)

# ln -s /tmp/mysql.sock /tmp/kde-mysql/ksycoca

4.Start MySQL Navigator

ex)

change to directory /usr/local/mysqlnavigator-1.3.11.binary

with Konqueror

click on mysqlnavigator-static

or

with terminalwindow

# mysqlnavigator-static &

You will get a window like this:

Click att Fila and choose New and you will get the following window:

You have to fill in the following as shown on this picture:

If you don't enter port number, the default value will be used (3306)

In the Socket field you have to enter /tmp/mysql.sock (The path you find earlier.

After you have entered all data, hit Save

When you look in the /root/.mysqlnavigator.rc you will find a part that will look somting like this:

<server>

<host>localhost</host>

<user>root</user>

<password>$</password>

<database>mysql</database>

<port></port>

<socket>/tmp/mysql.sock</socket>

</server>

After hitting Save you will get the following:

Close Server

Now you are prepared to work with MySQL Navigator.