On Tuesday 19 February 2002 07:45 pm, you wrote: > hmm, strange thing, > > did you ever set up a password for root? Nope defaule install, cant make changes to it even as root.. > -----CUT----- > % mysqladmin -uroot -P$passwordmysql > % mysqladmin --flush-privileges > -----CUT----- Tried that, seemed to go OK, no error messages but nothing changed > or even deeper, have the privilege-tables already been created? > -----CUT----- > % mysql_install_db > -----CUT----- Tried tha too, same problem, never have been asked for a password for root or any other user. > if you did that, you might also want to try > > -----CUT----- > % mysql_fix_privilege_tables > -----CUT----- Haven't tried that one yet, does it require root priv's?
> and, as a last guess, what kind of permissions does your mysql-database > directory have (probably /var/lib/mysql and /var/lib/mysql/mysql). I did change these and am able to create and modify passwordless DB's, still denied access as root or other users. > 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
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
