Varieur: Last identified 3 weeks ago
Manross: Varieur: is that channel specific, or chat-wide?
Varieur: Manross: ask NickServ.
Manross: Varieur: too much derp. I just realized I always hated that guy anyway.
Halvorson: My host call me my database is too big. How with phpmyadmin find the biggest table ?
Amauty: Katyucha:information_schema.tables
Eatman: Http://stackoverflow.com/questions/32421328/optimal-way-to-trigger-in-mysql
Koppelman: Ucgary: it work . must wait now OVH refresh its stat :/
Dair: In my SQL-query I have a floating point value, but If I access it in PHP it is an integer. Why?
Feinberg: Maybe a noobish question
Zediker: But its keeping me up already for two days
Corlew: And i cant figure out
Papelian: Stumbled trough google back and forward
Adamsonis: But: ERROR 2002 HY000: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ 2
Froebe: Whats am i doing wrong?
Michals: Does /var/run/mysqld/myslq.sock exist=
Burgen: Does your mysql server run?
Meininger: Last question yes it does
Debruler: If i can trust ps grep
Meckel: Does /var/run/mysqld/mysql.sock exist?
Kamaunu: First one: there is a file with 0 bytes
Hicken: What are the permissions?
Bettis: If you stop your mysql server, does this file still exist?
Fusselman: It exists wheb shutdown
Fogarty: That’s not a socket then
Knapke: Then start the mysql server again and check wether the file exists now with srwxrwxrwx 1 mysql mysql 0 . /var/run/mysqld/mysqld.sock
Blasz: Srwxrwxrwx 1 mysql mysql 0 sep 6 XX:14 mysqld.sock
Seaney: Good. now try to connect via socket
Kono: ERROR 2002 HY000: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ 2
Cormia: Does mysql treat “NULL” and “null” the same?
Falknor: Check wether /var/run/mysqld/mysql.sock exists and wether it is srwxrwxrwx
Slosser: Not mysqld.sock; that is on my system
Thamann: Nvm found the answer. The NULL value means “no data.” NULL can be written in any lettercase. A synonym is N case sensitive.
Meeuwsen: Srwxrwxrwx 1 mysql mysql 0 sep 6 XX:14 mysqld.sock
Beek: Okay. Your mysql server creates a myslqd.sock, your clients expects a mysql.sock
Vranich: How do you call the myslq-client to connect to the database?
Neuschwander: Mysql -uroot -p mysql ?
Balcomb: If so, try mysql –socket /var/run/mysql.sock -uroot -p mysql
Tisby: If this works, go to ~/.my.cnf and add this:
Monville: Socket=/var/run/mysql.sock
Mavai: ERROR 2002 HY000: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ 2
Pheonix: Are you sure you use the correct p***word?
Palay: That would be to stupid
Haughney: Stop; your client still tries to use myslq.sock, not myslqd.sock
Holyfield: And my client is my webserver?
Corprew: Try mysql –socket /var/run/mysqld.sock -uroot -p mysql
Toman: Hiawatha in this case?
Garret: Reading table information for completion of table and column names
Fregoe: You can turn off this feature to get a quicker startup with -A
Borcher: Welcome to the MySQL monitor. Commands end with ; or g.
Markham: Your MySQL connection id is 47
Pleil: Server version: 5.5.44-0+deb7u1-log Debian
Griffy: Copyright c 2000, 2015, Oracle and/or its affiliates. All rights reserved.