#mysql
30 December 2007
Total 14 pages. You are browsing page 3/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
03:06 <****> | mysql |
03:06 <****> | test
03:06 <****> thats all i left there now
03:06 <****> test is not a part of mysql afaik
03:06 <****> at least not here
03:07 <****> Lazarus: test is in there to play with
03:07 <****> okay
03:07 <****> so i can start playing making tables and stuff again ?
03:07 <****> you can even drop it
03:07 <****> Lazarus: but it presents a bit of security issue since no password is needed.
03:07 <****> test does?
03:07 <****> yes.
03:07 <****> Lazarus: so you should get rid of it.
03:07 <****> then ill drop it
03:08 <****> just drop it and whenever you want to play - create another db
03:08 <****> e.g. create database fuckmeimacow; :)
03:09 <****> can i wipe out the root pass for mysql again ?
03:10 <****> k
03:10 <****> now how does one specify a password to import this database ?
03:10 <****> mysql -u root < DATABASE_MYSQL.TXT
03:11 <****> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
03:11 <****> mysql -u root -p shit < shit_data.sql
03:11 <****> so i need to tell it to use a pass to connect
03:11 <****> btw db dumps are usually stored in .sql, not .txt
03:11 <****> it's good to get that habit
03:12 <****> hmmsomething is fucked
03:12 <****> ERROR 1062 (23000) at line 28: Duplicate entry 'localhost-postfix' for key 1
03:12 <****> its giving an error when i try to import database
03:13 <****> but there is no other database listed there
03:13 <****> it's just a wrong entry, not wrong db
03:13 <****> look at line 28 in the file
03:14 <****> k
03:15 <****> INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
03:16 <****> thats the line
03:16 <****> wait
03:16 <****> the line before it says USE mysql;
03:17 <****> does that refer to the database mysql ?
03:17 <****> yes
03:17 <****> as you can read there it is trying to register a new user in your db
03:17 <****> hmm
03:17 <****> so postfix can operate
03:18 <****> so mysql database already has a user there then ?
03:18 <****> Hello. I have a serious problem with MySQL Replication 5.1.x and its data nodes. Seemingly at random after hours or days of operation, one of the data nodes will have all queries in a frozen state. There are 40 queries on one of the data nodes with the 'state' being in 'end' and will not budge.
03:18 <****> Lazarus no
03:18 <****> for postfix ?
03:18 <****> INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
03:18 <****> For example, a simple query: UPDATE table SET a = 'test' WHERE x = '2' has been in the 'end' state for 73,000 seconds+.
03:18 <****> There are many other queries (with different tables in use) in the processlist with the same 'end' state, for around the same time (and less) listed.
03:18 <****> Lazarus: the mysql admin db stores usernames, passwords and grants.
03:18 <****> k
03:18 <****> so why is it causeing an error ?
03:18 <****> to be honest i have no clue
03:19 <****> Lazarus: the .sql file is trying to enter the same username
03:19 <****> probably because such user exists already
03:19 <****> indeed.
03:19 <****> what happens if i drop the database mysql ?
03:19 <****> just wipe that one line
03:19 <****> mate. think.
03:19 <****> Lazarus: don't!
03:19 <****> you were just told that mysql db is the INTERNAL subsystm of the whole mysql thing
03:19 <****> stores passwords, etc.
03:19 <****> Lazarus: the mysqld server won't work without it
03:19 <****> oh
03:19 <****> Lazarus delete that line from your .sql
03:20 <****> save
03:20 <****> what if i need it ?
03:20 <****> and try importing again
03:20 <****> so comment it out
03:20 <****> use --
03:20 <****> like -- INSERT...
03:20 <****> Lazarus: or you can remove that user from the mysql admin db
03:20 <****> the next line causes an error too
03:20 <****> that's right.
03:20 <****> ERROR 1062 (23000) at line 29: Duplicate entry 'localhost-postfix-postfix' for key 1
03:20 <****> Anyone have any help for me with regards to that serious issue? :(
03:21 <****> how do i remove a user?
03:21 <****> http://bugs.mysql.com/bug.php?id=31791 this bug appears to be what may be happening (the symptoms anyway).
03:21 <****> Lazarus it's a good moment to learn how to remove a user
03:21 <****> yeah
03:21 <****> so how do i remove a user?
03:21 <****> :)
03:21 <****> i'm out of mana, perhaps threnody will give you a hand job now ;)
03:21 <****> Lazarus: google?
03:21 <****> haha i knew that was coming
03:21 <****> Lazarus: revoke
03:21 <****> he he
03:22 <****> basically i'm same often... and i hate when people want me to read while i do want to finish some job fast
03:22 <****> Lazarus: http://dev.mysql.com/doc/refman/5.0/en/revoke.html
03:23 <****> Lazarus: or drop user. http://dev.mysql.com/doc/refman/5.0/en/drop-user.html
03:23 <****> while Lazarus is reading up.. folks, really no chance of resolve_ip() stuff in mysql?
03:23 <****> i really need it.
03:23 <****> err lookup_host() that is :)
03:24 <****> i'm having a nice geoip db setup and without dns access in mysql i can't efficently use it in shell
03:24 <****> unless you have an idea
03:24 <****> hmm didnt work
03:24 <****> DROP USER postfix;
03:24 <****> ERROR 1396 (HY000): Operation DROP USER failed for 'postfix'@'%'
03:24 <****>
03:25 <****> robboplus_: mysql can do dns lookups for remote connection reasons. http://dev.mysql.com/doc/refman/5.0/en/dns.html
03:25 <****> threnody hrhm...
Total 14 pages. You are browsing page 3/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last