What do you mean *all* the tables? Look in the directory mysql/data/ if there isn't anything in there, or the tables that are there - namely, user - are empty, you found your problem.
>-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson >Sent: Wednesday, February 20, 2002 11:18 PM >To: [EMAIL PROTECTED] >Subject: Re: [expert] MySql permissions and configuration > > > >Another thing that's strange, all the tables in /var/lib/mysql are empty. >Haven't looked at /usr/lib/mysql yet.. >On Tuesday 19 February 2002 07:45 pm, you wrote: >> hmm, strange thing, >> >> did you ever set up a password for root? >> >> -----CUT----- >> % mysqladmin -uroot -P$passwordmysql >> % mysqladmin --flush-privileges >> -----CUT----- >> >> or even deeper, have the privilege-tables already been created? >> -----CUT----- >> % mysql_install_db >> -----CUT----- >> >> if you did that, you might also want to try >> >> -----CUT----- >> % mysql_fix_privilege_tables >> -----CUT----- >> >> and, as a last guess, what kind of permissions does your mysql-database >> directory have (probably /var/lib/mysql and /var/lib/mysql/mysql). >> >> all the files and directories have to be read&change&writeable for the >> mysql-user >> >> hope it helps ... >> >> udo >> >> On Die, 2002-02-19 at 07:30, Ken Thompson wrote: >> > On Monday 18 February 2002 05:41 pm, you wrote: >> > > hi, >> > > >> > > my.cnf is **not** for setting up permissions like who is allowed to >> > > create/alter/update/etc tables. >> > > >> > > if you are not allowed to alter tables, it is **very** >likely that you >> > > have to "GRANT" the user you are using to connect to the database the >> > > relevant permissions: >> > > >> > > first log into the database: >> > > >> > > -----CUT------ >> > > % mysql -uroot -pTheMYSQLRootPasswordYouChose mysql >> > > -----CUT------ >> > > >> > > then tell the database who is allowed to do what: >> > > >> > > -----CUT------ >> > > GRANT INSERT,UPDATE,DELETE,.... ON foodatabase.* TO >$username@localhost >> > > IDENTIFIED BY "$password"; >> > > FLUSH PRIVILEGES; >> > > -----CUT------ >> > >> > I still get access denied to [EMAIL PROTECTED] >> > Even logged in as root eg: mysql -uroot -p >> > It let's me log in but won't let me do annnything.. >> > FWIW, i un-installed MySql and reinstalled it with urpm(e) & (i), same >> > problem. >> > >> > > that should be it. >> > > >> > > greets >> > > >> > > udo >> > > >> > > On Mon, 2002-02-18 at 23:30, Aron Pilhofer wrote: >> > > > I think (and don't quote me) you have to create the my.cnf file >> > > > yourself. I don't think it is required, but mysql will look for it >> > > > when it launches. Not 100 percent sure about that, but I >think that's >> > > > why you aren't finding it. >> > > > >> > > > However, the problem you're describing sounds like a permissions >> > > > issue - what error message are you getting when you try to create a >> > > > db? >> > > > >> > > > >-----Original Message----- >> > > > >From: [EMAIL PROTECTED] >> > > > >[mailto:[EMAIL PROTECTED]]On Behalf Of Ken Thompson >> > > > >Sent: Monday, February 18, 2002 5:21 PM >> > > > >To: [EMAIL PROTECTED] >> > > > >Subject: [expert] MySql permissions and configuration >> > > > > >> > > > > >> > > > >Where are the configuration files for MySql found? >> > > > > >> > > > >I've looked everywhere I can think of and still no joy. >> > > > >Looking in /etc/rc.d/init.d/mysql I found this bit of info, >> > > > >"# If you want to affect other MySQL variables, you should make >> > > > >your changes >> > > > ># in the /etc/my.cnf or other configuration files. >> > > > >" >> > > > >Locate doesn't find my.cnf anywhere on my system. >> > > > >The problem is that I can't use webmin or phpMyAdmin or the CLI to >> > > > >create a >> > > > >database. >> > > > >I can log onto the test db but that's as far as it goes. >> > > > >There has to be a global config file somewhere doesn't there?? >> > > > >Surley it's not gremlin powered <G>..... >> > > > >-- >> > > > > >> > > > >Ken Thompson, North West Antique Autos >> > > > >Payette, Idaho >> > > > >Email: [EMAIL PROTECTED] >> > > > >http://www.nwaa.com >> > > > >Sales and brokering of antique autos and parts. >> > > > > >> > > > >Linux- Coming Soon To A Desktop Near You >> > > > >Registered Linux User #183936 >> > > > >> > > > _________________________________________________________ >> > > > Do You Yahoo!? >> > > > Get your free @yahoo.com address at http://mail.yahoo.com >> > > > >> > > > >> > > > ---- >> > > > >> > > > >> > > > Want to buy your Pack or Services from MandrakeSoft? >> > > > Go to http://www.mandrakestore.com >> > >> > -- >> > >> > Ken Thompson, North West Antique Autos >> > Payette, Idaho >> > Email: [EMAIL PROTECTED] >> > http://www.nwaa.com >> > Sales and brokering of antique autos and parts. >> > >> > Linux- Coming Soon To A Desktop Near You >> > Registered Linux User #183936 >> > >> > >> > ---- >> > >> > >> > Want to buy your Pack or Services from MandrakeSoft? >> > Go to http://www.mandrakestore.com > >-- > > >Ken Thompson, North West Antique Autos >Payette, Idaho >Email: [EMAIL PROTECTED] >http://www.nwaa.com >Sales and brokering of antique autos and parts. > >Linux- Coming Soon To A Desktop Near You >Registered Linux User #183936 > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
