Danfield: Babcom: you might need to add some alternative mysql repos to get 5.6

Danfield: Google for some alternative repos for centos6. I know mariadb and percona and some mysql repos can be found

Dambach: I’d recommend IUS for Centos6 MySQL 5.6

Danfield: Dambach: Brittman was talking about that the other day but I couldn’t remember it, thanks.

Drow: Looking to create a table for users

Nazir: Needs an “id” column that auto increments

Pomeranz: And the username field should be unique

Soltren: I.e. no repeated usernames

Bertorelli: Also needs a p***word field just a varchar255

Buzbee: Any advice is welcomed :

Kothakota: Harbhub: See http://dev.mysql.com/doc/refman/5.6/en/create-table.html

Birman: Harbhub: See http://dev.mysql.com/doc/refman/5.6/en/alter-table.html

Doi: Yeah i’m looking at create table

Keiter: Harbhub: trivial to do if you follow the docs.

Sobery: Didn’t see how to make username field unique

Keiter: Harbhub: add a unique key / index.

Neslusan: I see the UNIQUE keyword

Martone: Hold on i’ll keep diggin

Amsden: Harbhub: The enter key or return key is not a substitute for punctuation. Use a period ‘.’, comma ‘,’, colon ‘:’, semi-colon ‘;’ emdash’–‘, or elipsis ‘.’ instead. In other words: DON’T HIT ENTER UNTIL YOU’RE DONE.

Romp: Oh sorry, my habit is to press enter as i type, i’ll try to work on that

Tancer: Keiter, can’t access anything it seems, and i’m not sure how to log in properly, i use: mysql –host=localhost –user=harbhub

Keiter: Harbhub: if you get an error, report it.

Tipple: Https://dev.mysql.com/doc/refman/5.5/en/connecting.html this isn’t helping me sadly

Winscott: It thinks i’m user ”, but i want/should be user ‘harbhub’

Keiter: Harbhub: run mysql_secure_installation

Cwalinski: Thanks but i’m going to have to work on other things for now, and set up mysql later it seems

Yokely: It is actually fast to do what you said it seems

Keiter: Yes, it won’t take long.

Majorga: Reload privilege tables?

Keiter: Harbhub: FLUSH PRIVILEGES;

Zumaya: I think the reload YES did the flush privileges on its own? or i need to do that now separately?

Keiter: Harbhub: the script did it for you.

Hollman: Awesome, thanks, i have it working now!

Brisbane: You are phenominal thumbs

Kertz: Can anyone help me with a quick query of a sort

Skuse: I know how to do it manually but a little confusion when putting it in code

Weeber: I just want to confirm I’m writing the Risse correctly

Hollopeter: Focus on explaining the requirement more than the Risse you are finding hard

Schmiesing: So I know you can do something like ‘select * from tablename where something = ?’, $variable

Pasquel: But what about if you want to do like

Keiter: Riceandbeans: don’t use LIKE and =

Androde: Like doesn’t have = after it.

Tillman: Well, manually it doesn’t

Motamedi: But if I’m doing ? I didn’t know

Schmitt: Which is why I’m asking

Mapston: Riceandbeans: The enter key or return key is not a substitute for punctuation. Use a period ‘.’, comma ‘,’, colon ‘:’, semi-colon ‘;’ emdash’–‘, or elipsis ‘.’ instead. In other words: DON’T HIT ENTER UNTIL YOU’RE DONE.

Risher: So I just say like ?, $variable ?

Cheam: Riceandbeans: Try it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok

Mayala: Riceandbeans: Try it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok