NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.

Forum Discussion

stuR's avatar
stuR
Follower
Mar 03, 2013

Lost in MySQL

Hello kind people

I would like to create 2 MySQL databases on my Duo v1 (for use with digiKam). Apologies but I'm pretty new to this. I've followed a couple of threads/faqs and installed PHP5, mySQLon, PhpMyAdmin, used configurePhpMyAdmin to: Name my server, set the connection type to socket, adjust the socket location to a standard one, allow logins without a password and have also set a bind-address to 0.0.0.0. I've also re-installed php and removed and re-installed PhpMyAdmin.

When I try to login in to PhpMyAdmin with root and no password, I get a 2002 Cannot login to the MySQL server. I presume that this is a bad thing - but should I have done something with MySQL directly first?

This is my configuration file.

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.4.10.1deb1~rnx0 setup script
* Date: Sun, 03 Mar 2013 22:58:19 +0000
*/

/* Servers configuration */
$i = 0;

/* Server: mynasServer [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'mynasServer';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['blowfish_secret'] = '5133bf7b9b3099.36274498';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>


Regards and thanks
Stu

2 Replies

Replies have been turned off for this discussion
  • Hi,

    Here another one with the same problem.
    Has anyone solved this?

NETGEAR Academy

Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology! 

Join Us!

ProSupport for Business

Comprehensive support plans for maximum network uptime and business peace of mind.

 

Learn More