NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Wilco87
Sep 07, 2013Aspirant
How to make database with PhpMyAdmin
Hi all there, this maybe a nOOb question but I have been trying allot and reading at google, still It aint working for me.
Can someone give me a start up on making the database server ?
This is what I got,
@ the admin page of my readynas I got :
Use PhpMyAdmin - Configure PhpMyAdmin
So when I go to Configure PhpMyAdmin and make a server over there, I cant seem to login @ PhpMyAdmin ..
I am running a few website also with databases but never had to make a database server before because I did external hosting on those.
Hope you get my problem and some can help me :-)
Greetings,
Wilco ( Netherlands ) (sorry if english is bad :lol: )
Can someone give me a start up on making the database server ?
This is what I got,
@ the admin page of my readynas I got :
Use PhpMyAdmin - Configure PhpMyAdmin
So when I go to Configure PhpMyAdmin and make a server over there, I cant seem to login @ PhpMyAdmin ..
I am running a few website also with databases but never had to make a database server before because I did external hosting on those.
Hope you get my problem and some can help me :-)
Greetings,
Wilco ( Netherlands ) (sorry if english is bad :lol: )
15 Replies
Replies have been turned off for this discussion
- Wilco87AspirantNo one ? Thats a shame I whould love to make a database, but for the database i first need to setup a server if I am not mistaken, but I cannot get that working :(
- http://demo.phpmyadmin.net/
https://phpmyadmin-english-united-kingd ... en/latest/
Basically, once you've got PHPMyAdmin configured, and you open it in your web browser, just click the "Database" Tab, and create your new database as required. - Wilco87AspirantHi there,
thanks for the response, I am stuck at the configuration of the server. I have to make a config.inc.php and upload it to the root folder of the installation of phpMyAdmin ( replace the standard one ) but how do I browse to this folder ? I cannot find it by normaly browsing the server.
Hope that someone can help me.
I think the title of my topic is / was wrong, I have a problem creating the database server. Not the database itself :-) - Wilco87AspirantOK, I made a server, just totaly standard, no config's changed to it ( only allow login without password )
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.0.5deb0rnx1 setup script
* Date: Sun, 15 Sep 2013 19:30:20 +0100
*/
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$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['DefaultLang'] = 'en';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['blowfish_secret'] = 'XxXxXxXxXxXxXxXxX';
$cfg['ServerDefault'] = 1;
?>
but still, I cannot login,
I keep getting the message that I cannot login without a password ( AllowNoPassword ) but as you can see in the code above it says " true " ...
When i put a password in it for the user, I get the message that I cannot login to the server with #1045 infront of it. - Wilco87AspirantWhere is all the support gone ? :'(
- I tried to find "WhoCares?" (Dev of many addons) small tutorial for getting setup properly with PHPMyAdmin, but unfortunately he's updated some of his website and the page that explains it is no longer showing.
But yes these boards are virtually dead these days. You might get "lucky" and get some folk offering help via Teamviewer but rarely do the posters post back any of the solutions they received.
Have you tried this?I got the message not allowed to login without password so i changed:
[READYNAS]:\webroot\phpadm\libraries\config.default.php
In the [config.default.php] file line 363:
$cfg['Servers'][$i]['AllowNoPassword'] = false;
to :
$cfg['Servers'][$i]['AllowNoPassword'] = true;
You are on a Duo v1 yes, the older SPARC model? - mdgm-ntgrNETGEAR Employee RetiredThe reason Teamviewer or other alternatives can be requested is that some problems can't easily be solved on the forum and can be solved more quickly via Remote Assistance. Also some problems require good familiarity with Linux shell commands to address (something which one wouldn't expect many users to have).
Also every case is different and for some issues symptoms may have a variety of causes which can mean that troubleshooting is quite an involved process. - Wilco87Aspirant
InTheShires wrote: I tried to find "WhoCares?" (Dev of many addons) small tutorial for getting setup properly with PHPMyAdmin, but unfortunately he's updated some of his website and the page that explains it is no longer showing.
But yes these boards are virtually dead these days. You might get "lucky" and get some folk offering help via Teamviewer but rarely do the posters post back any of the solutions they received.
Have you tried this?I got the message not allowed to login without password so i changed:
[READYNAS]:\webroot\phpadm\libraries\config.default.php
In the [config.default.php] file line 363:
$cfg['Servers'][$i]['AllowNoPassword'] = false;
to :
$cfg['Servers'][$i]['AllowNoPassword'] = true;
You are on a Duo v1 yes, the older SPARC model?
Hi,,
Thanks for your replay, yes I am on the V1 sparc model.
The folder you refer to doesnt exist, when I browse the server the normal way ( windows explorer ) but also not when i try to cd/foldername/ it in putty. The AllowNoPassword is at the True option, thats what i got so far in the PHPmyAdmin config module.
I made a server in that config area, I can change some settings, I can download the config.php file. But if I have that file, I cannot place it back because I have no folder to put it to. Still next to that its strange that if the no password is set to true, it stil doesnt login the server where I can setup databases and that kinda stuff. - Wilco87Aspirant
mdgm wrote: The reason Teamviewer or other alternatives can be requested is that some problems can't easily be solved on the forum and can be solved more quickly via Remote Assistance. Also some problems require good familiarity with Linux shell commands to address (something which one wouldn't expect many users to have).
Also every case is different and for some issues symptoms may have a variety of causes which can mean that troubleshooting is quite an involved process.
I get that,,, I dont know if my problem is a known issue, my oppinion is that its my first time ever working with MyPHPadmin as a installation ( I do use it on pre installed web hosts, but then I can just make the databases on a server ) so maybe its something real simple what I aint seeing. I cannot find a step by step guide what to do after installing the plugin. So thats whats giving me A hard time I think. - JarkodGuide
mdgm wrote: The reason Teamviewer or other alternatives can be requested is that some problems can't easily be solved on the forum and can be solved more quickly via Remote Assistance. Also some problems require good familiarity with Linux shell commands to address (something which one wouldn't expect many users to have).
Also every case is different and for some issues symptoms may have a variety of causes which can mean that troubleshooting is quite an involved process.
And at the end of a day there are many post unanswered because the problem was or wasn't solved via different communication channel.
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!