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
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
