NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
stuR
Mar 03, 2013Follower
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.
Regards and thanks
Stu
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
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!