5 minutes install – help

  • Resolved simi_id

    (@simi_id)


    13 years, 11 months ago

    Hi,

    In the install guide is written to create a database for wordpress.
    I’ve created database ‘wordpress’

    1. When installing and asking the user, I’ve typed ‘root’ and since there it has no password I’ve left the password tab blank. But it doesn’t work.
    2. The ‘root’ user which I use to login into mysql it’s the same user for accessing the databases, or I should create another ‘root’ for each database ?
    Or the ‘root’ used to login it’s a master of all databases and mysql ? I mean users are splited in 2 categories in mysql (for login and for database) or the same user at login has different rights for everything in there depends which were given when created ?
    3. When I create the database ‘wordpress’ I should also create a table ?
    4. How can I create a database and a user or asign a user to a database from mysql command prompt and also from phpmyadmin ?
    5. How do I login to mysql command prompt and add a password for root ? Cause I’ve installed EasyPHP and by default I saw it has no password.

    Thanks

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

  • Never use the root user. Create another user with full access privileges and a password for maximum security.

    I should also create a table

    No – WordPress will handle this during the installation process.

    If you’re running EasyPHP, it comes with PhpMyAdmin via the right-click context menu: Configuration -> PhpMyAdmin.

    Start up PhpMyAdmin
    Select the Privileges tab
    Select Add new User
    Add the new user’s name & password (make a note of these settings)
    Select “Grant all privileges on database ‘db_name'”
    Select “Go”.

    Thread Starter simi_id

    (@simi_id)

    I’ve followed the steps, but when installing wordpress on localhost (127.0.0.1:8888) it won’t pass by step 1, where I’ve to input username, password, database name, database host (tryed both localhost and 127.0.0.1:8888).
    I press Submit and nothing happens.

    I would check the port number (that is the :8888).

    If you can login via phpMyAdmin and select your wordpress database you should see at the top “Server:[sever name or IP]:[Port]” so it might be something like Server:localhost:8888. The part AFTER Server: is the hostname you need to add in your installation menu. Check your username and password are correct and the name of the database exists while you are logged in.

    Thread Starter simi_id

    (@simi_id)

    You were right datasoftict, but in phpMyAdmin in top left corner doesn’t display the port only 127.0.0.1
    I’ve installed MySQLWorkbench and when trying to connect I saw that it use port 3306 and WP worked with 127.0.0.1:3306
    So apache is on 8888 and mysql is on 3306.
    1 .Where can I change mysql port ?
    2. And also where can I see the port except mysqlworkbench.
    3. The user should be create right after i open phpmyadmin, or after I click on the left on wordpress_db ?
    4. How can I create a db for wordpress, a user and set/change the password, just connecting to mysql without phpmyadmin, it’s too confusing.
    5. The db password is hardcoded (just simply displayed) in wp-config.php ? Isn’t that dangerous ?
    6. Why wp isn’t giving an error and a reason when something is wrong as my port before, it’s just staying like that.
    7. If I manually edit wp-config.php, what’s with those keys ? Can I write whatever I want or is a rule ? What are they using for ?

    Thanks

    I can’t answer any of the questions regarding the design of WP as I didn’t design it.

    To take your questions one at a time.

    I amg gettting confused as to what you are doing. If you have root as a user without a password I would assume you are running this on your own server. I might be wrong but most hosting companies will assign a user name and password to you and this is how you connect. They will not pass root out as a user login.

    1. I don’t think you need to change your mysql port. It is set up on your server, mysql will ‘listen’ on port 3306 that is where you need to send your requests.

    2. If workbench can connect you to the Database, then use the same connection information to connect your WP installation to the database. Databases use connection strings, what works for one program that connects into your DB should work for all.

    3. In phpMyAdmin go into priveledges and then select add new user. This is per installation, not per database. Add the new user details – I can’t tell you the settings as I don’t know what versions you are using. Basically use textfields, local and give the permissions you want the user to have.

    4. You seem to have a wordpress DB in that you say “or after I click on the left on wordpress_db ?” so the wordpress databse must exist.

    5. 6. To do with WordPress and I will not comment on these points.

    7. The keys in wp-config are unique and allow secure communicatiuons/session files. Read this for more information. https://codex.www.ads-software.com/Editing_wp-config.php#Security_Keys

    I am sorry, I pressed post by mistake when reviewing my answer.

    When you have set up your new user, check with workbench that that user can connect to the mysql database then use those details in you wp-config. I am not sure but I would imagine the reason you have a problem with root connecting is because there is no password and WP will check for a valid password field.

    As has been said root should never be used for connections. I gives the login all system permissions, which is very bad news.

    Thread Starter simi_id

    (@simi_id)

    Thank you for your comprehensive answer.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘5 minutes install – help’ is closed to new replies.