Create mysql database

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Create mysql database

Postby kotoko » 04. January 2010 00:20

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
kotoko
 
Posts: 3
Joined: 04. January 2010 00:08

Re: Create mysql database

Postby Wiedmann » 04. January 2010 00:47

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

e.g. with phpMyAdmin.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Create mysql database

Postby kotoko » 04. January 2010 00:53

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
 
Posts: 3
Joined: 04. January 2010 00:08

Re: Create mysql database

Postby kotoko » 04. January 2010 01:22

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.
kotoko
 
Posts: 3
Joined: 04. January 2010 00:08


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 6 guests