mysqladmin setup problem

  • Resolved rikardlassenius

    (@rikardlassenius)


    17 years, 8 months ago

    yup, i’m total newbie but been able to install wordpress locally and tweek it quite a lot. now i’m trying to setup wordpress on our website and i just can’t figure it out. here’s a short descrpition of where i’m at.

    1. first i just made a folder on the root of our site and uploadad everything there – thought it will never work jsut like that, but you never know. it didn’t – the index.php says ‘error establisihng database connection’ blablabla

    2. ok, i thought i have to set up database – did it thru the admin pages of our website host.

    3. then got into mysqladmin and read all about setting it up. you can see that my database is there but i can’t do anything with it. it says no privileges, but there’s no way to cahnge that. there’s a button to make a new database but i can’t click on it etc. just how to add tables etc

    i don’t know how to access the whole thing or…

Viewing 7 replies - 1 through 7 (of 7 total)
  • yosemite

    (@yosemite)

    17 years, 8 months ago

    Theoretically you just ‘create’ a new database and nothing else (WordPress will populate it with tables appropriately).

    Creating a MySQL db requires a user/pass and a name for the database. With those 3 elements (and the hostname/IP of the MySQL server) you can fill in the required info in wp-config.php.

    Some hosts let you create the database. Some create it for you (this will require you finding out from your host what the db-name/pass/user/db-server is).

    Thread Starter rikardlassenius

    (@rikardlassenius)

    17 years, 8 months ago

    so, as i already setup a database on our server, i don’t need to go into mysqladmin? the server host gave me a username and password, after i gave it a name. but should the database be named wordpress?

    probably a stupid question, but how do they ‘connect’? the wp-files that sit in a folder in the root of my site and the database. i changed the settings in the general options (the 2 urls for the database and blog) and screwed everything up. but that’s another story…

    yosemite

    (@yosemite)

    17 years, 8 months ago

    so, as i already setup a database on our server, i don’t need to go into mysqladmin?
    Nah.

    the server host gave me a username and password, after i gave it a name. but should the database be named wordpress?
    Didn’t you just give it a name? Use that…

    how do they ‘connect’? the wp-files that sit in a folder in the root of my site and the database
    WP is coded for using MySQL already, all it needs to tie it together is that the 4 variables in wp-config.php to be accurate.

    Thread Starter rikardlassenius

    (@rikardlassenius)

    17 years, 8 months ago

    thanks again, something is happening…

    found the config file online and modified it. didn’t find the server first but then i realized that my given name was not it’s real name. the host server gave it a cryptic name. well, now that seems to work but the index.php says that ‘It doesn’t look like you’ve installed WP yet. Try running install.php.’ huh?

    by the way, di need to chage the DB_HOST in the config file? i guess it’s allright as it is.

    yosemite

    (@yosemite)

    17 years, 8 months ago

    If it’s not configured right it will let you know.

    As to running install, that makes sense. You’re supposed to do the db first, then install WP.

    Thread Starter rikardlassenius

    (@rikardlassenius)

    17 years, 8 months ago

    ok, thanks a million for your help.

    yosemite

    (@yosemite)

    17 years, 8 months ago

    Welcome!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘mysqladmin setup problem’ is closed to new replies.