Create mysql database

[kotoko]

Hello all!

I have successfully installed xampp on my Mac. I have searched all over but can't understand how to do the following in command line:

Code: Select all

create database redmine character set utf8;
create user 'redmine'@'localhost' identified by 'my_password';
grant all privileges on redmine.* to 'redmine'@'localhost';


In case it's usefull, I'm trying to install Redmine http://www.redmine.org/wiki/redmine/RedmineInstall

Any help will be very appreciated. I think I'm missing something pretty obvious :S

[Wiedmann]

but can't understand how to do the following in command line:

e.g. with phpMyAdmin.

[kotoko]

Is there no way to use mySql command line?

I just ask because I don't know mySql very well and wanted to make sure I follow the instructions correctly.

[kotoko]

So after a bit experiment what I'm uncertain about is the Collation and MySQL connection collation boxes.
According to the commands I want to follow what should I choose?

I'm afraid of testing because I haven't seen a clean way to delete a database.