Re: Granting access rights to a user

2010-11-18 Thread Tim Johnson
* Tim Johnson [101118 12:58]: > * Tim Johnson [101118 11:05]: > > using > > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu > > > > I have root access to the mysql command line. > > > > I need to grant access to user 'username' for all databases > > except for the mysql database for both

Re: Granting access rights to a user

2010-11-18 Thread Tim Johnson
* Tim Johnson [101118 11:05]: > using > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu > > I have root access to the mysql command line. > > I need to grant access to user 'username' for all databases > except for the mysql database for both onsite (cgi script) and > remote access. > >

Granting access rights to a user

2010-11-18 Thread Tim Johnson
using mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu I have root access to the mysql command line. I need to grant access to user 'username' for all databases except for the mysql database for both onsite (cgi script) and remote access. What is the syntax? -- Tim tim at johnsons-web.c