tag:blogger.com,1999:blog-1281882577011517327.post8629764238124158071..comments2009-11-07T00:47:14.920+01:00Comments on Hildeberto's Blog: Creating a New MySQL Database for DummiesHildeberto Mendonçahttp://www.blogger.com/profile/00241544229335976181noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1281882577011517327.post-55704457169904551952009-11-07T00:26:49.576+01:002009-11-07T00:26:49.576+01:00In short:
CREATE DATABASE db;
GRANT ALL PRIVILEG...In short:<br /><br />CREATE DATABASE db;<br /><br />GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' IDENTIFIED BY 'V3ryS3cretPa55Word!';<br /><br />FLUSH PRIVILEGES;<br /><br />The last is important, because in newer MySQL you can't login before it. It's just simply refresh the authentication 'module' of server.George Hronhttp://www.blogger.com/profile/15406106695993366523noreply@blogger.comtag:blogger.com,1999:blog-1281882577011517327.post-992298616523284192009-08-05T09:19:02.693+02:002009-08-05T09:19:02.693+02:00Brief and concise. ThanksBrief and concise. ThanksAnonymousnoreply@blogger.com