phpmyadmin doesn't work after installing php5-mysqlnd
I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute mysqli_result::fetch_all().
So I did my research and found out I only had to install the package php5-mysqlnd. So I did (apt-get install php5-mysqlnd). The installation did not fail and my PHP script could execute the mysqli_result::fetch_all() method.
However, phpmyadmin doesn't work anymore. It simply can't connect to the MySQL server anymore (all logins fail).
NOTE: every other script still has no problem connecting and logging in into the MySQL server. I also did not change any passwords. Login over the console is also possible.
I couldn't get it to work with the package installed. Then I reinstalled php5-mysql (which uninstalled php5-mysqlnd) and phpmyadmin worked again!
Not having the mysqli_result::fetch_all() method is not a major issue but if it is possible I would like to use it anyways. Simply because it is so convenient for debugging!
I am running a Nginx server and Debian 7.5 3.10.23 system.
debian php mysql nginx phpmyadmin
edited Apr 18 '15 at 1:05
slm♦
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
add a comment |
I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute mysqli_result::fetch_all().
So I did my research and found out I only had to install the package php5-mysqlnd. So I did (apt-get install php5-mysqlnd). The installation did not fail and my PHP script could execute the mysqli_result::fetch_all() method.
However, phpmyadmin doesn't work anymore. It simply can't connect to the MySQL server anymore (all logins fail).
NOTE: every other script still has no problem connecting and logging in into the MySQL server. I also did not change any passwords. Login over the console is also possible.
I couldn't get it to work with the package installed. Then I reinstalled php5-mysql (which uninstalled php5-mysqlnd) and phpmyadmin worked again!
Not having the mysqli_result::fetch_all() method is not a major issue but if it is possible I would like to use it anyways. Simply because it is so convenient for debugging!
I am running a Nginx server and Debian 7.5 3.10.23 system.
debian php mysql nginx phpmyadmin
edited Apr 18 '15 at 1:05
slm♦
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
No. I did not find any solutions.mysql_result::fetch_all()still doesn't work on my system.
– BrainStone
Jan 2 '15 at 18:55
add a comment |
I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute mysqli_result::fetch_all().
So I did my research and found out I only had to install the package php5-mysqlnd. So I did (apt-get install php5-mysqlnd). The installation did not fail and my PHP script could execute the mysqli_result::fetch_all() method.
However, phpmyadmin doesn't work anymore. It simply can't connect to the MySQL server anymore (all logins fail).
NOTE: every other script still has no problem connecting and logging in into the MySQL server. I also did not change any passwords. Login over the console is also possible.
I couldn't get it to work with the package installed. Then I reinstalled php5-mysql (which uninstalled php5-mysqlnd) and phpmyadmin worked again!
Not having the mysqli_result::fetch_all() method is not a major issue but if it is possible I would like to use it anyways. Simply because it is so convenient for debugging!
I am running a Nginx server and Debian 7.5 3.10.23 system.
debian php mysql nginx phpmyadmin
edited Apr 18 '15 at 1:05
slm♦
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute mysqli_result::fetch_all().
So I did my research and found out I only had to install the package php5-mysqlnd. So I did (apt-get install php5-mysqlnd). The installation did not fail and my PHP script could execute the mysqli_result::fetch_all() method.
However, phpmyadmin doesn't work anymore. It simply can't connect to the MySQL server anymore (all logins fail).
NOTE: every other script still has no problem connecting and logging in into the MySQL server. I also did not change any passwords. Login over the console is also possible.
I couldn't get it to work with the package installed. Then I reinstalled php5-mysql (which uninstalled php5-mysqlnd) and phpmyadmin worked again!
Not having the mysqli_result::fetch_all() method is not a major issue but if it is possible I would like to use it anyways. Simply because it is so convenient for debugging!
I am running a Nginx server and Debian 7.5 3.10.23 system.
debian php mysql nginx phpmyadmin
debian php mysql nginx phpmyadmin
edited Apr 18 '15 at 1:05
slm♦
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
edited Apr 18 '15 at 1:05
slm♦
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
edited Apr 18 '15 at 1:05
slm♦
246k66507673
edited Apr 18 '15 at 1:05
slm♦
246k66507673
edited Apr 18 '15 at 1:05
slm♦
246k66507673
246k66507673
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
asked Jun 6 '14 at 19:01
BrainStone
1,14871941
1,14871941
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
No. I did not find any solutions.mysql_result::fetch_all()still doesn't work on my system.
– BrainStone
Jan 2 '15 at 18:55
add a comment |
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
No. I did not find any solutions.mysql_result::fetch_all()still doesn't work on my system.
– BrainStone
Jan 2 '15 at 18:55
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
No. I did not find any solutions.
mysql_result::fetch_all() still doesn't work on my system.– BrainStone
Jan 2 '15 at 18:55
No. I did not find any solutions.
mysql_result::fetch_all() still doesn't work on my system.– BrainStone
Jan 2 '15 at 18:55
add a comment |
1 Answer
1
active
oldest
votes
Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually.
I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd.
The errors i was getting were From phpmyadmin only.
Cannot log in to the MySQL server
2003 Cannot log in to the MySQL server
1043 Cannot log in to the MySQL server
After installing phpmyadmin from apt-get, I basically thought "start from scratch" with configuration.
For me, it was this configuration, that was the difference between being able to login to phpmyadmin and not:
$cfg['Servers'][$i]['ssl'] = true;
I removed that option and could login. No idea why!
I would suggest getting a blank template of config.inc.php and adding only the mandatory parameters and seeing what happens...
answered Jan 3 '15 at 2:33
Benno
1011
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "106"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f134907%2fphpmyadmin-doesnt-work-after-installing-php5-mysqlnd%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually.
I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd.
The errors i was getting were From phpmyadmin only.
Cannot log in to the MySQL server
2003 Cannot log in to the MySQL server
1043 Cannot log in to the MySQL server
After installing phpmyadmin from apt-get, I basically thought "start from scratch" with configuration.
For me, it was this configuration, that was the difference between being able to login to phpmyadmin and not:
$cfg['Servers'][$i]['ssl'] = true;
I removed that option and could login. No idea why!
I would suggest getting a blank template of config.inc.php and adding only the mandatory parameters and seeing what happens...
answered Jan 3 '15 at 2:33
Benno
1011
add a comment |
Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually.
I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd.
The errors i was getting were From phpmyadmin only.
Cannot log in to the MySQL server
2003 Cannot log in to the MySQL server
1043 Cannot log in to the MySQL server
After installing phpmyadmin from apt-get, I basically thought "start from scratch" with configuration.
For me, it was this configuration, that was the difference between being able to login to phpmyadmin and not:
$cfg['Servers'][$i]['ssl'] = true;
I removed that option and could login. No idea why!
I would suggest getting a blank template of config.inc.php and adding only the mandatory parameters and seeing what happens...
answered Jan 3 '15 at 2:33
Benno
1011
add a comment |
Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually.
I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd.
The errors i was getting were From phpmyadmin only.
Cannot log in to the MySQL server
2003 Cannot log in to the MySQL server
1043 Cannot log in to the MySQL server
After installing phpmyadmin from apt-get, I basically thought "start from scratch" with configuration.
For me, it was this configuration, that was the difference between being able to login to phpmyadmin and not:
$cfg['Servers'][$i]['ssl'] = true;
I removed that option and could login. No idea why!
I would suggest getting a blank template of config.inc.php and adding only the mandatory parameters and seeing what happens...
answered Jan 3 '15 at 2:33
Benno
1011
Not sure if this will help you, but I had originally just wget'd phpmyadmin in and set it up manually.
I changed it to using apt-get install phpmyadmin. I also had issues with php5-mysql and php5-mysqlnd not being compatible versions, so I had to remove php5-mysql on all servers and add php5-mysqlnd.
The errors i was getting were From phpmyadmin only.
Cannot log in to the MySQL server
2003 Cannot log in to the MySQL server
1043 Cannot log in to the MySQL server
After installing phpmyadmin from apt-get, I basically thought "start from scratch" with configuration.
For me, it was this configuration, that was the difference between being able to login to phpmyadmin and not:
$cfg['Servers'][$i]['ssl'] = true;
I removed that option and could login. No idea why!
I would suggest getting a blank template of config.inc.php and adding only the mandatory parameters and seeing what happens...
answered Jan 3 '15 at 2:33
Benno
1011
answered Jan 3 '15 at 2:33
Benno
1011
answered Jan 3 '15 at 2:33
Benno
1011
answered Jan 3 '15 at 2:33
Benno
1011
1011
add a comment |
add a comment |
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f134907%2fphpmyadmin-doesnt-work-after-installing-php5-mysqlnd%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I'm having the exact same issue. Did you figure it out BrainStone?
– Benno
Jan 2 '15 at 16:23
No. I did not find any solutions.
mysql_result::fetch_all()still doesn't work on my system.– BrainStone
Jan 2 '15 at 18:55