> > In regards to the above I did the following: > 1. Remover MySQL server from Big_Nate. Correct. > 2. Attempted to start MySQL in Reality_Check good. _ > > [In case you are wandering the computers are lettered a, > b, c et with the first letter of the name being the > letter. A is Alley Oop and all the rest are named after > comic book characters hopefully with the appropriate > commic book name which describes the user.] > > Anyway, found that my attempts to use a different > directory than /var/lib/mysql had locked the computer > into "Can not connect to MySQL through socket > /var/lib/mysql.sock (2)" again
> Attempts to change this > directory have been, in time elapsed not work time, a 3 > week long battle which I have now placed on hold. Anyway > the easiest way for me to solve that issue was to remove > the mysql RPMs, power down, reinstall the rpm, power down > and presto I was in after 45 minutes and several > attempts. There has to be an easier way but I can not > imagine what it is that I could not screw up so even > though this sounds ridiculous to you people welcome to > the world of a newbie which actually I believe should be > tenderfoot not newbie. > > Anyway, no more story, this being just enough to give you > a feeling of my world. > > > Assuming this is the case then sitting at big_nate, you > > can type: > > mysql -h IP-address-of-reality_check -u your-user-name > > -p test > > type in your password and access the test database > > I then did as Steve suggested here entering > mysql -h 192.168.1.2 -u root -p test > > Password appeared > I entered <password> > > and I got: > Error: Access denied for user. That means that you didn't setup a root account when you first started MySQL. You should have one for localhost and the IP of your server. But that doesn't matter as far as OOo is concerned. > > Just to check connection I just accessed Reality_Check > from Big_Nate by fish and SSH which worked just fine. > > Also just to check that MySQL server is working I did: > show databases; and got > test > mysql > GorkSearch > GorkSearch2 > > I then did: > drop database GorkSearch2; > > followed by > show databases; and got > test > mysql > GorkSearch > Which I believe proves that MySQL server is functioning > in some capacity. > > > Can you do that? Leave all the other stuff for later. > > The main thing is to get MySQL installed properly > > first. Cheers, Steve. > > Yes, so in other words you _can_ do that. So 192.168.1.2 is the server and you've removed the server software from your client. The problem now is the OOo software. So fire up 2.0 beta and. . . tools>options>java>add>path to your mandrake jre(if it's not already highlighted, otherwise install it) tools>options>java>class path>add archive>the .jar file I sent you restart OOo 2.0 file>new>database>connect to existing databse>mysql>next>connect using JDBC>test>192.168.1.2>3306>com.mysql.jdbc.Driver>finish Closer? Good luck, Steve. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
