Wednesday, March 1, 2006

MySQL Server over the network - Linux Forums

MySQL Server over the network - Linux Forums
Error 1130, remote connecting access denied.
MySQL and Linux Tutorial

To allow network access:
GRANT ALL on * TO 'username' IDENTIFIED BY 'user password'
FLUSH PRIVILEGES


Some notes on the MySQL/Java connection with the MySQL® Connector/J (mysql-connector-java).
After installing it you need to change the CLASSPATH or you'l get errors like com.java.driver something not found..
For the bash shell prompt that I use in SuSE 10.0 I created a file in my home dir: .bashrc

~username/.bashrc
---------------------
export CLASSPATH=$CLASSPATH:/opt/mysql-connector-java-3.1.12/mysql-connector-java-3.1.12-bin.jar

**make sure its one line, with no line breaks in it!
Info for other Shell prompts

No comments: