Author: jiri.janak

I had a fresh install of RHEL 6.6 with MySQL 5.1.73. When i tried to reset MySQL root password for MySQL, it hadn’t worked. Reason was, that mysql.user table was empty, there was no ‘root’ user created.

Following helped me to resolve the issue:

1. Restart MySQL like this:
   service mysqld restart --skip-grant-tables
    
2. Enter MySQLfrom the command line (no password needed at this point)
   # mysql
    
3. Do desc mysql.user
    

   You will see 17 rows for MySQL 4.1
   You will see 37 rows for MySQL 5.0
   You will see 39 rows for MySQL 5.1
   You will see 42 rows for MySQL 5.5

   You will have to tweak each privilege since the GRANT command does not work will skip-grant-tables is enabled

4. For MySQL 5.1, you can enter a new root@localhost whose password is ‘whatever’ as follows:
    
   

   DELETE FROM mysql.user WHERE user='root' AND host='localhost';
   INSERT INTO mysql.user SET
                     Host = 'localhost',
                     User = 'root',
                 Password = PASSWORD('whatever'),
              Select_priv = 'Y',
              Insert_priv = 'Y',
              Update_priv = 'Y',
              Delete_priv = 'Y',
              Create_priv = 'Y',
                Drop_priv = 'Y',
              Reload_priv = 'Y',
            Shutdown_priv = 'Y',
             Process_priv = 'Y',
                File_priv = 'Y',
               Grant_priv = 'Y',
          References_priv = 'Y',
               Index_priv = 'Y',
               Alter_priv = 'Y',
             Show_db_priv = 'Y',
               Super_priv = 'Y',
    Create_tmp_table_priv = 'Y',
         Lock_tables_priv = 'Y',
             Execute_priv = 'Y',
          Repl_slave_priv = 'Y',
         Repl_client_priv = 'Y',
         Create_view_priv = 'Y',
           Show_view_priv = 'Y',
      Create_routine_priv = 'Y',
       Alter_routine_priv = 'Y',
         Create_user_priv = 'Y',
               Event_priv = 'Y',
             Trigger_priv = 'Y',
                 ssl_type = '',
                 ssl_cipher = '',
                x509_issuer = '',
               x509_subject = '',
              max_questions = 0,
                max_updates = 0;

5. Restart MySQL
   service mysqld restart

Source: Database Administrators Stack Exchange

I could connect to my account from the phone (Nokia C7) and I could also reach my account on internet, but I was not able to sign-in to my account in Nokia Suite.

Nokia Suite connects to the server account.nokia.com and auth.gfx.ms. For these servers, SSL 3 was disabled on October 15th 2014. As of today, these servers require TLS 1.0. Nokia Suite does not use TLS 1.0 but only SSL 3, because Nokia Suite uses the QT framework 4.7.4. Up to that version, the QtNetwork class QSslSocket used SSL 3 and not TLS 1.0 as default protocol.

Issue can be resolved by replacing a DLL file:

1. exit the Nokia Suite via right-click in (bottom, left) Windows Notification Area (system tray)
2. download this modified version of ssleay32.dll (local copy for a case it would get deleted ssleay32.zip)
3. replace this file at C:\Program Files (x86)\Nokia\Nokia Suite\

Source: Nokia Support Discussions