Configuring mysql fo network access...

Anon

I know the answer will be "RTFM" - I just can't find the right "F" page... Help much appreciated...

I am trying to install mysql on one box , accessed by apache/php on another box. I am assuming the mysql server goes on box one and mysql client goes on box two, with apache/php told where the client is when they are compiled .I am a bit hazy on the details though... Could someone direct me to a good resource to baby me through it? I am compiling from tarballs as I need 2 byte support....

I know I can do the below and get it all on one box...

groupadd mysql
useradd -g mysql mysql
gunzip < mysql-VERSION.tar.gz | tar -xvf -
cd mysql-VERSION
./configure --prefix=/usr/local/mysql --with-charset=sjis --enable-bcmath=yes --enable-force-cgi-redirect=yes --enable-discard-path=yes --enable-safe-mode=yes --with-exec-dir=/usr/bin --enable-track-vars=yes --enable-memory-limit=yes
make
make install
scripts/mysql_install_db
chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql

Anon

Hello Nick (Hi baby),

configuring mysql for networkaccess is not that hard. Get mysql up and running. Install PhpMyAdmin if you like that tool and play with the tables in the mysql-database, ie. user, db, host, etc...

Please remember to 'reload mysql' before testing the changes you made.

A good tool to test the connection from a client machine is the mysql-client: 'mysql'.
There is even a windows-version (260Kb)!

ex. mysql -h 10.0.0.141 -u root -p

You can also use the client-program: 'mysqladmin' to reload the grant tables whenever necessary, instead of using 'reload mysql' in PhpMyAdmin.

Have fun,

Rik

Anon

Thanks Rik! I was having this same problem....till I looked at the user table.