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