Problems creating a new user with phpMyAdmin

  • A few days ago I tried installing WordPress on our MySQL 3.23.54 and ran into problems almost immediately. Using phpMyAdmin, I create the blog database, create a new user called ‘blogger’ (who can log in from any host), give him a password, reload the server, grant him a couple of permissions (just general permissions now, to make sure it works), reload the server then log out and try to log in as this ‘blogger’ and can’t log in.

    After running into this problem, I tried following the MySQL terminal directions on the installation page, but once it was done I was still unable to log in and ‘blogger’ didn’t even show up on the users table when I looked at it with phpMyAdmin.

    I have a feeling this problem might have a really simple solution, but I’ll be damned if I know what it is. Can anyone offer a better idea of what I’m doing wrong?

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

  • “A few days ago I tried installing WordPress on our MySQL 3.23.54 and ran into problems almost immediately”

    What problems?

    “..grant him a couple of permissions (just general permissions now, to make sure it works)”

    Installing_WordPress#Using_phpMyAdmin recommends granting ALL permissions.

    ********************
    Welcome to the WordPress Support Forums!

    Please help keep the Forums successful by reading:
    Using the Support Forums

    Also, remember the WordPress Codex and the FAQ pages.

    And, thank you, for letting us know if this information proves useful (or not)!
    ********************

    Thread Starter runcible

    (@runcible)

    I’ve tried granting all permisssions on the blog database too, but I still can’t log in as this user, even though he’s on the users table. A collegue suggested that the user be explicitly added on localhost and not the generic “all hosts”. I’ve tried it, but it didn’t help – I still can’t create a user on this server that I can actually log in as. What could be causing this?

    I can’t understand why you are making a new user.

    Create a database.
    Create a user for that database.
    Link the two in the webhost control panel.
    Install WP
    That’s it.

    There is no need to go near phpmyadmin.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Problems creating a new user with phpMyAdmin’ is closed to new replies.