<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>Comments on snippet: 'Command line instructions to create a database in MySQL'</title>
<link>http://snipplr.com</link>
<description>Snipplr comments feed'</description>
<language>en-us</language>
<pubDate>Mon, 13 Feb 2012 23:09:54 GMT</pubDate>
<item>
<title>stevewa said on 7/9/10</title>
<link>http://snipplr.com/view/875/command-line-instructions-to-create-a-database-in-mysql/</link>
<description><![CDATA[ on Ubunutu 10, this would not work
when i removed the 2 single quotes around database name, then it worked.

just replace the databasename with the actual name of the databse you want to create...
and replace username with your real username...
and replace hostname with the name of your ubuntu server, usually "localhost" will work as the name of the host...
and replace password with the ubunutu password for the username you typed before...

so on ubuntu:

mysql> CREATE DATABASE databsename ;
mysql> GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'hostname' IDENTIFIED BY 'password' ;
mysql> FLUSH PRIVILEGES ;
mysql> exit ]]></description>
<pubDate>Fri, 09 Jul 2010 01:21:49 GMT</pubDate>
<guid>http://snipplr.com/view/875/command-line-instructions-to-create-a-database-in-mysql/</guid>
</item>
</channel>
</rss>
