Documenting Problems That Were Difficult To Find The Answer To

Monthly Archives: December 2013

Help! I Created A New User In PhpMyAdmin But Cannot Log In That User

I downloaded the latest phpMyAdmin (v4.1.2). I installed MySQL v5.5.34-0ubuntu0.12.04.1.

I proceeded to create a user with no global privileges and privileges on a single database.

Then I tried to log in from the command line using my new user and password (in this case the user was phpmyadmin and the password was also phpmyadmin):

user@host:~$ mysql -u phpmyadmin phpmyadmin --password=phpmyadmin
ERROR 1045 (28000): Access denied for user 'phpmyadmin'@'localhost' (using pasword: YES)

It turned out that I needed to use the PASSWORD function in MySQL itself to create the password rather than relying on phpMyAdmin’s password generation function.

user@host:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.5.34-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;

Database changed
mysql> update user set password=PASSWORD('phpmyadmin') where user = 'phpmyadmin';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q

After this I could log in as user phpmyadmin with password phpmyadmin!

If that didn’t work then, with MariaDB, I was forced to run (for user dbuser authorised to access mydb):

GRANT ALL PRIVILEGES ON mydb TO 'dbuser'@'%' IDENTIFIED BY 'dbpass';

Finally something that could prevent a password from being accepted is the “plugin” column.

mysql> use mysql;

Database changed
mysql> update user set plugin='' where user = 'phpmyadmin';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q

Help! Windows 8.1 Is Demanding I Log In Using An Email Address During Upgrade From Windows 8!

If you’re searching for this solution you might have searched for:

  • how can I log into Windows 8.1 without an e-mail address during the upgrade process?
  • I want to log into Windows 8.1 with my existing account after upgrading
  • help, I don’t want to register a Hotmail address with Windows 8.1 just to upgrade!

The Problem

In an incredible act of what appears to be a selfish grab of personal information Microsoft seemingly demand you log into Windows 8.1 with a Hotmail (or Windows Live) e-mail account.

You go through the process of upgrading Windows 8.1 on your computer. And finally you think you’re about to log in for the first time! So you log in as yourself (as you’ve always done in Windows 8) and after that it tells you to provide an e-mail address!



There is a link you can click on at this stage to “Register a new e-mail address”. Follow this.

Then change the drop down of default e-mail providers and select “provide my own”. Enter a fake e-mail address.

On the bottom-left of the screen will be an option to just log in using your existing account. Click this.

Where’s The Information Commissioner?

That’s it! It’s not obvious – and you actually have to go through some of the steps of registering a new e-mail account to bypass the whole e-mail login process. Which is not obvious and Microsoft have probably conned many unsuspecting users into coughing up their personal information (first name and last name) to Microsoft.

I’m surprised regulatory bodies haven’t come down hard on Microsoft for this incredibly gross breach of privacy and making it look like there’s no way of using your existing local account to log in. Shame on Microsoft – this is truly outrageous behaviour.