LinuxSA Mailing list archives

  From: David Lloyd <lloy0076@rebel.net.au>
  To  : Bordeaux Stan <stan.bordeaux@dchs.tas.gov.au>
  Date: Mon, 29 Jan 2001 08:59:42 +1030

Re: mysql problem

Hi There!

> attempting to create a database as a user but get an access denied message
> whenever I try and do something.  If I log on as su I get full access to
> mysql.  I tried giving the /usr/share/mysql directory full permissions for
> all by issuing a chmod cmd, but still can seem to get access as a user.  Any

Firstly, that's not a UNIX problem. The MySQL database has its own
authorisation scheme and doesn't let just any user log onto it and
access the data. Why don't you goto http://www.mysql.com/ and check out
their rather hefty documentation? Look especially for terms such as
"security", "authorisation". If you've got a later version you will need
to use the "GRANT" SQL statment.

You'll also find a host of links to various projects from that address.
You could also try searching on MySQL on (http://freshmeat.net/). MySQL
has been bound to virtually every modern language available (PERL, C,
PHP, C++) and has many tools to access it other than the ones that come
with it. In fact, the little frontend that comes with it is really just
a test example of what it can do.

You could lookup a book called "MySQL" by publisher New Riders. It's
very good. But the documentation should be fine as well - it's not quite
as polished as the book (i.e. it's written by programmers and I think
it's undergone translation to English) but it's technically correct.

DSL
-- 
For the beauty of the earth
 For the glory of the skies
 For the love which o'er and
'round us lies...

-- 
LinuxSA WWW: http://www.linuxsa.org.au/  IRC: #linuxsa on irc.linux.org.au
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject