Please could anyone help with step 3 ("Data") of the Gallery 2 "preparing to install" instructions

stefanaalten
stefanaalten's picture

Joined: 2004-08-23
Posts: 38
Posted: Wed, 2009-10-28 00:56

I am persevering with the long set of instructions to install Gallery 2 ... but am stuck again :-( and would appreciate some more help.

I'm stuck on the following step on: http://codex.gallery2.org/Gallery2:How_do_I_Install_Gallery2, under "Preparing to install", item 3 "Data", the instructions say:

MySQL Instructions
$ mysqladmin -uroot create gallery2
$ mysql gallery2 -uroot -e"GRANT ALL ON gallery2.* TO username@localhost IDENTIFIED BY 'password'"

I don't have the mysqladmin application (I do have SSH access but the command "mysqladmin" is not recognised). My ISP (aplus.net) does make a MySQL Database Manager available on the web-based control panel but this does not let me type in any commands - it just lets me create a database and a database user, which I have done:
database "gallery2database_stefan_site_aplus_net",
user "stefan705620"
(these names are generated by the tool & I can't change them).

Any ideas how I can complete this step without using "mysqladmin"?

Many thanks in advance.

System info:

Gallery 1 was at www.gallery.aaltenvoogd.com (but now out of service as renamed the folder to "g1" as part of the g2 installation instructions.
PHP 5.2.9
Apache 11
OS: Linux (on ISP's servers)
Browser: Firefox, Chrome, IE8, Safari on iPhone

Login or register to post comments
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 9283
Posted: Wed, 2009-10-28 03:20

Go to your host's control panel and add a MySQL database to your account. You don't need to type in any commands that way. You just need a database and the information needed to connect to it:

hostname
database name
username
password
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

Login or register to post comments