Hi
I'm a new boy to Linux/Ubuntu and I've got a problem. I've setup a UBUNTU Workstation 8.04.2. (the reason for Workstation is the GUI). Installed all the updates.
Installed apache 2
ruby1.8
rails
mysql-sqlserver-5.0

I've got a backup of a database I've restored to this machine. I've successfully transfered the program and got it up and running.

I can see it from any pc using a web browser using its internal ip address http://192.168.220.30/DBase/people

So now I want to access it via ODBC so that I can generate reports. I've got the correct ODBC driver installed on the windows PCs (It works fine accessing another UBUNTU server's DBase).

For the life of me I can't figure out how I tell the server to permit access??!!! I've surched everywhere. The MySQL site suggests:

$ CREATE USER (blah blah blah) in the /etc/mysql subdirectory

I've tried this but it doesn't recognise the "CREATE" command. Lord knows why.

I've also tried:
$ SHOW GRANTS for admin@localhost (this I believe should be a default) and the UBUNTU says it doesn't recognise the"SHOW" command and that I should

$ apt-get install nmh

Which I did do - with no success.

As you can see - I don't know what I'm doing. I'm trying hard but ignorance is definitely a no no with this OS!!! Anyone got any suggestions!!!

I'm no expert, and I'm sure others will give you better and fuller advice, but to kick off:

Those CREATE USER and SHOW GRANTS commands you found are mysql commands, not Ubuntu. So you need to go into mysql first with:

where 'user' is your mysql username (or possibly 'root' if you haven't set up additional users).

When you are in mysql, remember to end mysql commands with a semi-colon or they won't execute.

Other things to check are whether there is a firewall (either on your Ubuntu server, or in a router on the network) blocking the MySql port which is 3306 as standard.

Also check if your /etc/hosts.allow and /etc/hosts.deny files are set up correctly and not stopping connections. You can Google these or

for more info.

Hope that's helpful for starters.

Hi Ivanmaxx,

Thanks alot for that... You see!!! I didn't even realise that. I know what my MySQL username and password is so I'll go in and give it a try.

Thaks again.