help installing phpmyadmin to create database?

  • I’m stupid, I’ve searched the forums about these two and I didn’t really understand what was posted, if anyone has an answer for these please don’t hesitate to use extremely dumbed-down language because I’m honestly not that web-savvy, it already took me a lot of google-fu to get this far ??

    BACKGROUND: I’ve installed wordpress onto my webhost and comicpress and comic press manager into the appropriate directories. I use Filezilla FTP service to transfer and https://www.fourthewin.org/chuwei is my website/domain, the domain is shared with other friends who set up the domain/webhost. I’m okay with HTML/JAVA/CSS and simple website creation/management but I have no idea what MySQL is, I don’t understand it at all, or even how to access it on my website. I run Windows XP

    QUESTION#1 I’m stuck at the configuring the wp-config-sample.php file because I don’t know what to put in the fields, and also stuck with creating the database/username step. I’m assuming this is different from the username/password I use to log into my domain for FTP?

    QUESTION#2 Is it possible to create a database and user name for this just from using Filezilla (or maybe dreamweaver)?

    QUESTION#3 I downloaded phpMyAdmin, but when I searched on how to install it, it said that I also need to install the Apache Web Server, Install the MySQL Database Server, and Install the PHP Engine before I can even install the phpMyAdmin. Are all of those installations really necessary or can I skip some of them?

    I would rather not to have to pay someone for this since I’m just a student and all I wanted was to have an easy to use comic website template… :S

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

  • Typically most hosts already provide phpMyAdmin to their customers so you might check with them.

    Also review Installing WordPress for details on the database and database user.

    Thread Starter shuura

    (@shuura)

    Thank you! I found how how to access the phpMyadmin from my webhost, but when I try to use /wp-admin/install.php in my firefox browser nothing happens.

    I created a mySQL database named “xyz” in the root directory because that was the only place I could put it. But the database “xyz” doesn’t show up when I connect to the webhost using filezilla. WordPress and all its contents are installed into a subdirectory under https://www.fourthewin.org/chuwei/ffxi/wordpress, when i put /wp-admin/install.php first a page with wordpress logo and very messy coding appeared along with a message saying wordpress is already installed, to clear database if i want to reinstall, then I attempted to open “www.fourthewin.org/chuwei/ffxi/wordpress/wp-admin/install.php” but nothing happens

    also I am confused on how to access the dashboard ..

    You won’t see the database when connecting via FTP–usually the database is kept somewhere else by your host–that’s why they give you phpMyAdmin and typically a method to create databases and database users.

    Please talk to your host about creating databases and database user–then use that information to complete your wp-config.php. Again Installing WordPress is a good resource.

    Thread Starter shuura

    (@shuura)

    thank you for all your help so far, I have been using and following the Installing WordPress guide to the best of my ability but I unable to access the control panel that changes the privileges on the phpMyAdmin screen, the username, host name and MySQL database name and password etc have all been set up already and I’m confident I will be able to properly edit the /wp-config.php file later,

    However: my webhost runs version 3.1.5 of phpMyAdmin, I think this is different from the version the WordPress installation guide because I cannot find any link to change privileges. I clicked on the Home icon and this is what it looks like. I tried clicking through all the possible links and tabs but did not find anything remotely similar to the description in the WordPress installation guide about usernames and checkboxes and setting global privileges. I am also not familiar with SQL queries so I don’t know how to change it manually via the MySQL client either.

    I tried going to the MySQL tab and copy pasting the command

    “mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
    -> IDENTIFIED BY “password”;”

    into the “Run SQL query/queries on server ” box by replacing the databasename and wordpressusername and password I created and using the localhost for the host name, but that didnt’ work either so I am running out of ideas on how to get past this granting user privilege step..

    I was a bit confused, but got pass those steps.

    Check your wp-config.php

    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘XYZ’);

    /** MySQL database username */
    define(‘DB_USER’, ‘user of your database’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘password.’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    Warning- localhost (127.0.0.1) may not be the correct hostname for your database. Consult your host and ask them what the hostname should be if localhost or 127.0.0.1 does not work.

    phpMyAdmin is what you use to create or delete a database. You can use it to create a user and password for the database you created.

    —–“mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
    -> IDENTIFIED BY “password”;——

    mysql> is the COMMAND LINE. This would be IF you owned or had direct access to the computer. Since the server is on your host, you likely will NOT have command line access.

    1. So you would use PhpMyAdmin to create the MySQL database, user, and user password.

    2. You would then put that information into wp-config.php

    Thread Starter shuura

    (@shuura)

    @esok I have already done all that :/ my problem is granting privileges to the username I created for the mySQL database.

    My understanding is that you could use PhPMyAdmin to grant privileges to the MySQL database. Maybe you want to double check.

    I have direct access to my own MySQL database, so I can go to the command line or use GUI tools.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘help installing phpmyadmin to create database?’ is closed to new replies.