Asked  7 Months ago    Answers:  5   Viewed   78 times

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.

I got this when I opened up phpmyadmin ...

Any way to fix this?

 Answers

68

It's just a warning to show that there is no password for the default user root. If you want to set password for root:

  1. Open phpmyadmin interface
  2. Click "Users" tab
  3. Select user "root"
  4. Edit Privileges
  5. Change password
Saturday, May 29, 2021
 
Lance
answered 7 Months ago
35
UPDATE your_table 
    SET extra = substring_index(email, ' ', -1), 
        email = substring_index(email,' ',1);
Wednesday, March 31, 2021
 
hohner
answered 9 Months ago
27

I solve this annoying problem by following instructions below:

  1. open /etc/php5/apache2/php.ini
  2. find ;session.save_path = "/tmp", this line may look also like this ;session.save_path = "/var/lib/php5"
  3. remove first semicolon from this line
  4. restart apache by executing sudo service apache2 restart

FYI: I work under Ubuntu 12.04 with apache2, php5, phpMyAdmin 4.0.5 so for different systems and servers file path may be a little different.

In case of any troubles check if directory from step 2. is writable for server.

Good luck.

Wednesday, March 31, 2021
 
John_BSDthos
answered 9 Months ago
82

Are you nesting your brackets correctly? I don't think NSLog() likes taking only one argument, which is what you're passing it. Also, it already does the formatting for you. Why not just do this?

NSLog(@"%@ %@, %@", 
   errorMsgFormat, 
   error, 
   [error userInfo]);              

Or, since you say errorMsgFormat is a format string with a single placeholder, are you trying to do this?

NSLog(@"%@, %@", [NSString stringWithFormat:errorMsgFormat, error], 
   [error userInfo]);              
Wednesday, June 2, 2021
 
Precastic
answered 6 Months ago
45

The config.inc.php file is not required, and only needed for custom configurations

phpmyadmin will first refer to ./libraries/config.default.php to retrieve the default values.

If for some reason you need to modify the default values, and the ./config.inc.php file doesn't exist, you will need to create one as per the Installation documentation.

You will also need to configure pmadb for some of phpmyadmin's special features such as bookmarks.

Monday, August 16, 2021
 
conmen
answered 4 Months ago
Only authorized users can answer the question. Please sign in first, or register a free account.
Not the answer you're looking for? Browse other questions tagged :
 
Share