#mysql
21 October 2007
Total 22 pages. You are browsing page 2/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:16 <****> can someone help me with MySQL
00:16 <****> i need to set it up for MythTV
00:17 <****> I'm looking for a way to create a user with *all* the same permissions as another user in my MySQL database. I have two users I didn't create, Root and WP-ADMIN who I can access from pages run either on the same server as the database or on a remote page accessing the database, respectively, and I'd like to create a third username with access that they each have from their respective hosts, however, I cannot find how to do this.
00:17 <****> same error
00:17 <****> sivik: mysqld --user=mysql using OS user root
00:17 <****> sivik: su root.
00:17 <****> ok, thanks, word 'desc' is reserved.
00:17 <****> nnivanov: right, and the other thing i said too
00:17 <****> http://pastebin.com/m170e2c18
00:18 <****> sivik: you cannot ignore half of what i say. su root. YOU MUST BE THE ROOT USER
00:18 <****> same error no matter what i do
00:18 <****> i have already done it, do you not see that it says root
00:18 <****> "mysqld --user=mysql" is the command. literally do not change it. run this command as root
00:18 <****> i'm not changing it
00:18 <****> yes you are
00:19 <****> you typed mysql --user=root
00:19 <****> http://pastebin.com/m62f6d539
00:19 <****> chadmaynard: but where is 'unsigned' should be?
00:19 <****> did you not see the new mysql pastebin
00:19 <****> sivik: good!
00:19 <****> sivik: You posted the wrong url, prior to that.
00:19 <****> nnivanov: right after the datatype. int, tinyint, etc
00:19 <****> ok, sorry
00:19 <****> !perror 13
00:19 <****> System error: 13 = Permission denied
00:20 <****> chadmaynard: many thanks!
00:20 <****> but the user and group for the files that i looked at were mysql
00:20 <****> so what am i doing wrong?
00:20 <****> sivik: you can delete that ibdata1 file since you don't have any innodata. But check the own of that directory and everything in it
00:21 <****> sivik: Check the directory ownership and permission as well as of any existing files.
00:21 <****> ok
00:21 <****> the mysql folder in the /var/lib is drwxr-xr-x mysql:mysql
00:22 <****> we'd love for you to pastebin the output of ls -l /var/lib/mysql. takes guesswork out for us
00:22 <****> sivik: You may have created some files owned by root prior to this. ls -lR ...
00:22 <****> http://pastebin.com/m1a42fa40
00:22 <****> goodbye
00:22 <****> Xgc: i dont know how, its a clean system
00:23 <****> sivik: you see root?
00:23 <****> chadmaynard, thats what it did when it installed
00:23 <****> chadmaynard, do they all need to be mysql:mysql?
00:23 <****> sivik: The word root seems to be there.
00:23 <****> sivik: chown mysql:mysql -R /var/lib/mysql
00:24 <****> i know how to change the owner of a file, this isn't my first time to use this os, i just don't use mysql much and didn't have a problem on my other box
00:24 <****> http://pastebin.com/m7af78245
00:25 <****> sivik: ls -lR ...
00:25 <****> i already pastebined
00:25 <****> http://pastebin.com/m7af78245
00:25 <****> sivik: mysql is empty?
00:25 <****> that's ls -l
00:25 <****> Xgc said ls -lR
00:26 <****> although It will probably start now
00:26 <****> http://pastebin.com/m2d098f84
00:26 <****> sivik: Really, I'm not trying to be annoying. Don't assume everything we say is with that intent.
00:26 <****> ok
00:26 <****> can i do a between type query
00:26 <****> sivik: Looks good.
00:26 <****> ok
00:26 <****> sivik: Still the same error?
00:26 <****> trying to start
00:26 <****> i.e. WHERE 4044223 is between start AND end
00:27 <****> http://pastebin.com/m22169587
00:27 <****> mattcrane: yes
00:27 <****> mattcrane: WHERE 123 BETWEEN start AND end
00:27 <****> oh. whoops
00:27 <****> Pretty close.
00:27 * chadmaynard skips words when he reads sometimes
00:28 <****> sivik: Now we need to find the next error.
00:28 <****> Xgc: ok, what do i need to check now
00:28 <****> sivik: you need to produce an error message again.
00:28 <****> sivik: There should be another error somewhere, maybe socket related.
00:28 <****> ok, then what should i try now?
00:29 <****> sivik: check the log
00:29 <****> which log?
00:29 <****> the .err log
00:29 <****> sivik: or you can use mysqld --user=mysql as root again.
00:29 <****> That's usually easier.
00:30 <****> http://pastebin.com/m286bea65
00:30 <****> i'm assuming your log is empty due to perms. that will cause fatal errors too
00:30 <****> i'm rebooting because i need to update some other stuff, like the new version of the kernel so i can install my drivers
00:30 <****> what's with 071020 17:35:07 [Warning] Ignoring user change to 'mysql' because the user was set to 'sivik' earlier on the command line?
00:30 <****> sivik: It almost seems like your datadir specification could be wrong.
00:31 <****> i rebooted, to see if that would fix and installed a new kernel
00:31 <****> 071020 17:35:07 [Warning] Ignoring user change to 'mysql' because the user was set to 'sivik' earlier on the command line
00:31 <****> we need to see my.cnf too. it shouldn't run as user sivik
00:31 <****> ok
00:31 <****> give me a second to bring it back up
00:31 <****> sivik: That's the problem, most likely.
00:31 <****> Xgc: i agree. but what's that about?
00:31 <****> sivik: it's not changing to the mysql user.
00:31 <****> yes
00:32 <****> he is root OS user now. maybe in my.cnf
00:32 <****> chadmaynard: He's not root or some script is playing badly by setting the user to sivik.
00:32 <****> Could be the config file, but the command line option should override that.
00:32 <****> Xgc: he is calling the mysqld binary directly though
00:32 <****> chadmaynard: Right. See above.
00:33 <****> Comand line options should always override.
00:33 <****> ok, now local on the box
00:34 <****> sivik_: log in as root
00:34 <****> sivik: Directly as root or su - root, not just su root.
00:35 <****> http://pastebin.com/m2c97708c
Total 22 pages. You are browsing page 2/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last