| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> qett your mysqld is not running
<1> thats right, i think
<1> it wont run because of mysql.sock
<1> which it cant find
<0> note my spelling!
<0> mysqld
<1> yeah
<1> ill run it now..
<1> ./etc/rc.d/mysqld start
<1> result: FAILED
<1> in big red letters
<2> run it manually
<0> now find out why
<1> cant connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2)
<2> .. not mysql
<1> why? i think because that file doesnt exist
<2> msqld
<0> mysqld creates the sock file
<2> the DAEMON
<1> wait, another error sorry
<1> ./etc/rc.d/mysqld: line 17 ...etc
<1> [: mysql:x:1000:102:MySQL: unary operator expected
<2> yeah what about it
<1> bug in the code?
<2> just start mysqld via: mysqldsafe
<3> the code that works for everyone else here you mean ?
<1> mysqldsafe? where is that?
<4> qett: what os?
<1> arch linus
<1> s=x
<4> what os?
<4> s/os/distro/ if you like
<3> archlinux is a distro jink ...
<4> it is?
<3> yup
<1> :)
<4> kk
<3> is supposed to be quite nice but then they all claim that :P
<1> ./join #archlinux
<4> how did you install?
<1> pacman -S mysql
<2> o_O ;)
<1> which downloads the tarball
<1> and installs it, afaik.. :S
<4> kk, should be fine, i suppose :)
<2> qett just find the mysqldsafe binary and run it
<4> on my debian machine that's mysqld_safe
<1> search turns up nothing :(
<1> wait
<1> underscore
<1> works
<4> there ya go :)
<1> errors galore!
<1> i will paste..
<1> touch: cannot touch '/usr/local/mysql/data/myhost.err': no such file or directory exists
<1> chown: cannot access '/usr/local/mysql/data/myhost.err': no such file or directory
<4> does /usr/local/mysql/data/ exist?
<2> well it gives that because you're not p***ing the datadir and basedir params to mysqld_safe
<2> depends what your archlinux set them too during configuration
<1> that directory doesnt exist
<1> it goes as far as: /usr/local
<2> but you can always just create the directory, and let mysqld do the rest
<1> whats the command to create a directory?
<2> ...
<4> ... indeed
<2> mkdir
<1> ty
<1> thanks for the help
<1> so far
<1> should i make an empty file myhost.err?
<2> sure
<5> umm. what is the point of declaring in input to an SP being declared as int if it can be null on the way in?
<5> shouldn't it complain?
<1> ok, now when i run mysqld_safe: starting mysqld daemon ... \n STOPPING server from pid file ... \n <some numbers> mysqld ended
<2> check the log now qett
<1> i guess i have to give "access rights" to mysql, or something.. how do i do that?
<2> why, whats the error
<1> error: "this error means mysqld does not have the acces rights to the directory. file name ./ibdatal. file operation call: 'create'"
<2> yeah just do a: chown -R mysql:mysql /usr/local/mysql
<1> aha thanks
<6> they need !pwned
<7> is there a file or something to set pager in mysql-cli?
<6> try \G
<7> \G?
<7> where?
<1> noooo more errors: [error] can't start server: bind on unix socket: permission denied
<1> [error] do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
<6> end of the query
<6> select * from foo\G
<7> on moment
<7> *one
<2> qett: ps ax | grep mysqld
<1> nothing
<1> so mysqld isnt running right?
<2> yeah, does the file exist /var/lib/mysql/mysql.sock ?
<7> alphablue: sql error
<1> no
<2> did mysqld_safe give you that error?
<1> that file doesnt exist
<1> and mysql.sock doesnt exist anywhere.. i tried searching
<7> i mean i want use "set pager less -niSFX" always
<6> oh oh pager..
<6> hmm dunno
<6> i use limit 1
<6> :/
<2> qett ?
<2> doesnt look like a mysqld_safe error.. is it from mysqld_safe or from your rc script ?
<7> pager also useful on looooooooooooooooong tables, then need scroll screen
<1> ahh
<1> hang on
<1> i ran "/etc/rc.d/mysqld start" again
<1> this time it didnt stop
<2> use mysqld_safe til it works.
<2> then start debugging the init script
<1> ps as | grep mysqld returned something
<2> ok so its running now
<1> yeah
<2> good
<1> what now?
<2> now go on your knees and say your sorry for saying mysql ****s, and say I ****
<1> LOL
<1> ill say: thanks for helping me
<1> but
<1> mysqld doesnt mean that mysql is runnign right?
<2> of course it does
<2> try: mysql -u root
<1> error
<1> ./var/lib/mysql/mysql.sock again :(
<2> well, did you run via mysqld_safe or init script_\
<1> i ran mysqld_safe
<1> which didnt work
<2> which error?
<1> ok, mysqld_safe just says: starting ... \n STOPPING
<1> the error file says:
<2> yeah well the other one is still running eh
<2> kill it first
<2> ps ax | grep mysql
<2> and kill everything there
<2> then try starting the daemon via mysqld_safe
<2> check where the swocket is created, so you can then use that socket path with mysql cli
<2> anyway, i'm in a lecture
<2> need to listen
<2> you'll figure it out
<1> hmm
<8> umm
<8> is it possible in mysql to sort.. a table with two fields A,B so that each row is where A = last row's B if possible?
<8> ie 1,4 4,7 7,9 etc
<0> order by a [asc|desc] ,b [asc|desc]
<4> archivist: that won't make sure that a in the second row is b from the first row
<0> if thats what he really means
<4> that's what i understand from the example "ie 1,4 4,7 7,9 etc"
Return to
#mysql
or
Go to some related
logs:
how to install the InfoPipe module
.googleair .exe
storkme
5dwm setup
#linux
#linux
#physics
#ubuntu
ASCII roflwaffle
#math
|
|