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
