Adame, ah. I see one.

 
Butterbaugh: Hi. can anyone help me out? i need to create a mysql database to install a script to my website. i have a dedicated server without a control panel. here’s the instructions “Create an empty database via your hosting control panel. And keep the host-name, database name, username and p***word ready”

Rhoderick: I’ve created the database in mysql but i don’t know what to do from here? how to get the host-name? username and p***word?

Okun: Also i created the db from root mysql, is that wrong?

Ekwall: SELECT default_character_set_name FROM information_schema.SCHEMATA shows mostly latin1 . is it safe for me to change everything to utf8?

Fadel: Anyone here use mysql?

Lacerenza: Funyun: See http://dev.mysql.com/doc/refman/5.6/en/create-user.html

Rumery: Funyun, hostname is the server address you use to connect to mysql – most probably “localhost” in case your app server and mysql server are on the same machine; you will need to create some user and grant it access to the new database do not use root directly in app

Hittner: Funyun: See http://dev.mysql.com/doc/refman/5.6/en/grant.html

Mansanares: Danblack, Rumery: so create a new user, then create the db, then grant the user access?

Rumery: Funyun, you can create the db and then create the user – they are not “connected” until the grant, so that order does not matter

Dockery: Oh okay. i think i understand now. thank you guys so much

Bisignano: Danblack: worked. thanks again

Tadena: How do I grant INSERT/ALTER/CREATE on a table that doesn’t exist now

Blanzy: But may exist in the future?

Wison: Ktechmidas: 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

Gueth: Danblack: already done. that’s why I asked

Volcko: Might be the wildcard

Lars: But the wildcard is needed

Branford: ERROR 1146 42S02: Table ‘zanadu_db.channel_management_log_%’ doesn’t exist

Stankovic: Ktechmidas: See http://dev.mysql.com/doc/refman/5.6/en/grant.html

Beiter: Wildcard is only mentioned for databases, not tables

Giarrusso: Any way around this you can think of?

Lipsie: Except granting on the entire database.

Adame: I have a problem: http://sqlfiddle.com/#!9/0d9edf

Adame: Want to get latest last_update_date and FROM_UNIXTIMElast_update_date, but. something goes wrong

Adame: Using this query: select dsl.account_id,grouped_dsl.last_update_date,FROM_UNIXTIMEgrouped_dsl.last_update_date,grouped_dsl.max_id from diesel dsl inner join select account_id, last_update_date, maxid as max_id from diesel group by account_id grouped_dsl on dsl.account_id = grouped_dsl.account_id and dsl.id = grouped_dsl.max_id;

Colicchio: Adame: select . order by last_update_date desc limit 1;

Rumery: Adame, you cannot select the date column from the subquery like this,, the group by will group multiple rows – max can take care of that, but just selecting a column will pick a random value from the grouped rows

Volcko: Add an index on that column too

Rumery: I think i saw this yesterday – for the query to work the way it is written, you need to select he additional columns directly from dsl

Rumery: Http://sqlfiddle.com/#!9/0d9edf/3

Rumery: But the orderby limit solution will be much easier

Adame: Rumery: OK. I’ll try again. I have this script: http://pastebin.com/rnA6YFCu and I want to optimize it

Adame: Rumery: is it possible?

Rumery: Adame, and you did it quite well, just change the table you take the date from – it should work, is there some problem with it?

Rumery: Adame, or do as danblack suggested – “select account_id,last_update_date,FROM_UNIXTIMElast_update_date FROM diesel ORDER BY id DESC LIMIT 1”

Panessa: Order by last_update_date DESC LIMIT 1

Rumery: Adame, ah. I see one problem – your “optimized” query takes max depending on account_id one row per each account even but your original script takes just one last id not taking account_id into accoutn