#mysql

10 October 2007

Total 18 pages. You are browsing page 18/18.

First :: Prev :: [...] [14] [15] [16] [17] [18] :: Next :: Last

23:50 <****> i just want to wipe all rows in there
23:50 <****> when I use INSERT INTO photos (title,weight,description) VALUES('sometitle', MAX(weight)+1,'hi')
23:50 <****> blobaugh|sp, would that be safer than starting as root ???
23:50 <****> and i rarely delete stuff so don't know how to do that
23:50 <****> blobaugh|sp, or it`s the same ...
23:51 <****> robboplus: remove the *
23:51 <****> oh hm.
23:51 <****> many thanks dkr!
23:51 <****> that worked :)
23:51 <****> freebird: you have to run it at root period
23:52 <****> blobaugh|sp, I see, so I will just keep running as root ...
23:52 <****> yup
23:52 <****> the security is just fine. its built to be run that way
23:52 <****> you need to make sure that your mysql users have correct permissions and strong passwords. thats where it gets weak
23:53 <****> /var/lib/mysql should be owned by the user you want to run mysql as
23:53 <****> (likely cause of error message above)
23:53 <****> right, it will _run_ as that user, but it has to be started as root
23:53 <****> dkr, being from the group is not enought ?
23:53 <****> i did not make that clear enough, sorry
23:54 <****> blobaugh|sp, wow, so, I`ve user root and user freebird, I want to do the safest thing, should I start mysql under root or freebird ???
23:56 <****> well, mysql should be owned by someone other than root. i have a mysql user. if someone got into the mysql account they couldnt do anything with my system. but like i said, only root can open the network port, that is why when you start mysql it has to be done as root. then it uses whatever user mysql is owned by
23:58 <****> blobaugh|sp, I`m reading this book, it says
--- Log closed Thu Oct 11 00:00:07 2007

Total 18 pages. You are browsing page 18/18.

First :: Prev :: [...] [14] [15] [16] [17] [18] :: Next :: Last