-4
votes
2answers
24 views

MySQL incorrect result of insert [closed]

Created table 'testload' on demo database (int (15)) ...
0
votes
1answer
57 views

Updating phpMyAdmin that works with MySQL 5.1.73

I have recently setup a Xen VPS hosting (CentOS 6/512MB RAM/20GB HDD) for my WordPress based website. My current phpMyAdmin version is 4.1.7 and the current MySQL version is 5.1.73. I wanted to ...
0
votes
1answer
47 views

installing phpmyadmin for remote db host

I am having trouble trying to install phpmyadmin. We are using AWS services for our servers. Our mysql db is located in an RDS instance. Now I am trying to install phpmyadmin on an EC2 instance. I ...
0
votes
0answers
30 views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP [migrated]

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
0
votes
0answers
44 views

Token Mismatch When Accessing RDS Instance Through phpMyAdmin on localhost

Having problems using phpMyAdmin with a RDS instance. This is the guide that I used. phpMyAdmin is installed on my Windows 7 laptop and I can connect to the RDS instance and I can see the databases ...
1
vote
0answers
68 views

PhpMyAdmin Hangs On MySQL Error

I'm currently running PhpMyAdmin 4.0.10 (the latest version supporting PHP 4.2.X) on my Amazon EC2 connecting to a MySQL database on RDS. Everything works perfectly fine except actions that return a ...
-3
votes
1answer
31 views

How to solve this odd error in mysql? [closed]

I upgraded mysql 5.5 to 5.6 in directadmin and now http://p30rank.ir/phpmyadmin/ has error #2002 - No such file or directory The server is not responding (or the local server's socket is not ...
0
votes
2answers
83 views

phpmyadmin won't connect to remote MySQL instance

I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server. I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all. I have configured the ...
1
vote
1answer
65 views

Phpmyadmin table disappears, but website reads it perfectly

When I log into phpmyadmin, it only shows the information_schema. I have only one table that has been showing perfectly, but one day it decided not to show up. My website reads all the information in ...
1
vote
1answer
399 views

Can't login to remote MariaDB server with phpMyAdmin, but works in shell

I recently configured two servers. The first to use Apache and phpMyAdmin. On the other server I have a maria-DB server correctly configured. phpMyAdmin it's reading the config file, but I can't ...
1
vote
2answers
122 views

Connect to Mysql from internet works, but when i try from mysql query browser it's failed (Err. 2003)

i can connect to mysql-phpmyadmin throught internet from browser(i.e google chrom), but when i try it from mysql query browser it's always failed. It's always show error 2003. i already created ...
0
votes
1answer
21 views

Finding out when an MySQL user was added?

I was just looking through my MySQL user databases (for all the MySQL users in PhpMyadmin) and noticed something exceedingly alarming, a user named darkangel with all permissions. I havent looked in a ...
1
vote
0answers
91 views

Elastic Beanstalk w/ RDS and PHPmyAdmin

I'm trying to configure a Drupal CMS on my new Amazon EC2 server with Elastic Beanstalk PHP. I also have MySQL configured for my RDS database. I want to get PHPmyAdmin running for use with Drupal. I ...
-1
votes
1answer
47 views

How to find a database location on server using phpmyadmin?

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ? Running ...
0
votes
1answer
46 views

Why would PHPMyAdmin connections fail when connections from the same server with the same credentials succeed?

I have a site hosted on Rackspace Cloud. It runs Joomla 2.5, some test scripts, and PHPMyAdmin 4.1.6. Joomla runs off a database hosted in Rackspace Cloud. The host is ...
2
votes
1answer
284 views

PhpMyAdmin - connection was reset error

I am getting this error when I am trying to upload a backup of my site (.sql) in phpmyadmin. The size of file is 15 MB and after zipping it, its 9 MB. Can anyone help me out with this. I have ...
2
votes
1answer
572 views

MySQL: “UPDATE command denied to user ''@'localhost'” [duplicate]

For some reason when I installed MySQL on my machine (a Mac running OS X 10.9) the 'root' MySQL account got messed up and I don't have access to it, but I do have access to the standard MySQL account ...
-1
votes
1answer
95 views

MariaDB 10.0.4 different mysqlclient reported

I use MariaDB-server 10.0.4 on my CentOS 6.4 64-bit server. PHPMyAdmin shows: libmysql - 10.0.4-MariaDB While phpinfo shows: Client API version 5.3.12-MariaDB Why I got two versions ? How to ...
2
votes
3answers
58 views

Accessing mysql DB remotely

I became in charge of a legacy website, which was written by someone else that is now not available, and has no CMS - just pure php and html. It's not written very well, but that's my problem... Some ...
0
votes
2answers
97 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
0
votes
1answer
156 views

Myphpadmin Hiding Databases

I have a client that wants to use myphpadmin to manage his mysql database 5.x on my server. I found this article on how to hide databases from myphpadmin but I don't like this because if I don't ...
1
vote
1answer
197 views

How to setup phpmyadmin without prompts in one line? [duplicate]

i'd like to setup phpmyadmin in Ubuntu without asking for parameters in prompts, i don't know if there's a way to pass these parameters in the command: sudo apt-get install phpmyadmin and give the ...
0
votes
1answer
61 views

Clear “failed login attempts” in MySQL (without restart?)

In phpMyAdmin it displays how many failed, aborted and successfull login attempts I have on the server. I put up some iptables rules and want to see how it's going now. I want to reset the stats ...
1
vote
1answer
72 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
0
votes
0answers
77 views

Strange CPU cycles and slow queries

My database (XAMPP) runs at almost 350 questions a second is 99% in the SELECT category. The website I'm running is heave on timed ajax calls that refresh data every 10 seconds. During this, there are ...
-5
votes
1answer
45 views

Process still running from a deleted chroot? [closed]

so I come to you with a somewhat interesting problem. I had a chroot running that had an entire lamp server installed and running on it. I tried to purge and remove the lamp server but messed up ...
0
votes
1answer
353 views

Give non-root user access to log into phpMyAdmin [closed]

I'm attempting to give a non-root mysql user access to log into phpMyAdmin and only see the DB they have access to. I've already looked at the following articles and tried their advice: Configuring ...
0
votes
0answers
70 views

Cant connect to mysql server

I'm trying to configure a freshly installed mysql server to listen on port 3306. I've removed skip_networking, I have changed bind-address=172.20.33.1 (which is my server ip) and it completely ...
0
votes
2answers
761 views

How do I get my ubuntu server to listen for database connections?

I am having a problems connecting to my database outside of phpmyadmin. Im pretty sure this is because my server isn't listening on port 3306. When I type: sudo netstat -ntlp on my OTHER working ...
0
votes
0answers
104 views

Mysql database on ubuntu server not accepting connections

I am having problems with my database. The only way I can connect to it is via phpmyadmin. I try to use the same username and password to connect to the database in 'SQL PRO' and I get the following ...
0
votes
1answer
65 views

Table Locking - Large number of inserts - How do I identify the source of the inserts?

I usually post on Stack Overflow, but I think this may be the more appropriate forum for this question.... I have a dedicated server that servers several million pages monthly. We use LAMP. We're ...
1
vote
1answer
634 views

Enable MySQL to use more than 1 core (multicore)

I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28 Is there a way to ...
1
vote
2answers
1k views

Error message with phpmyadmin when starting up apache

I'm trying to get phpmyadmin working with mysql(mariadb fork). I get this error message in the browser when I try to access phpmyadmin: > phpMyAdmin - Error The mysqli extension is missing. ...
0
votes
1answer
180 views

Why is my phpMyAdmin page not interpreted from raw PHP code?

I am quite new to website construction. I have been practicing with MySQL and phpMyAdmin before, but only on localhost. It went well. But when I actually bought myself a domain name and changed the ...
0
votes
0answers
1k views

phpMyAdmin gives #1040 Cannot log in to the MySQL server error after a few weeks

I am running MySQL and phpMyAdmin (under Apache) on a CentOS VPS, everything works fine, but after a few weeks services using the database start having issues and all users except for root get the ...
0
votes
1answer
61 views

MySQL table records changes every second

I was using a PHP script running on background to grab data and insert them into the mysql database... i stopped the PHP from logging and checked the table records, i found that its being changed ...
-1
votes
1answer
251 views

Can not access phpmyadmin in ubuntu server #2003 error while logging in

I set up a LAMP server on Ubuntu server. Now the thing is that PHP and Mysql are all properly installed and do work. Now I got phpmyadmin installed and connected to my host. Everything works fine ...
0
votes
2answers
120 views

I am trying to setup phpMyAdmin to use with a remote MySQL databases on Scientific Linux release 6.2

I am trying to setup phpMyAdmin to use with a remote MySQL databases on Scientific Linux release 6.2. If I use the mysql command line to connect to the remote database it works great but if I use ...
0
votes
3answers
388 views

How to update phpmyadmin on hosted website? [closed]

I have a personal home page and I decided to start a server. I use ipage.com and their phpmyadmin is an old version. How to update to the newest 3rd version? I've read documentations and the problem ...
0
votes
1answer
804 views

Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

We have installed PHPMyAdmin on a windows machine running IIS 7.0. We are able to connect to MySQL using command-line, But we are not able to connect using PHPMyAdmin. The error displayed is: Error ...
0
votes
0answers
30 views

MySQL 5.0 Unavailable but still working every monday morning

So I have a MySQL server with 4-5 databases and every monday morning, I can't login with PHPmyAdmin or the cmd line tools or options and the funny thing is the connection can be made later in the day ...
0
votes
1answer
82 views

MySQL broke; how can I save some of the tables?

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables. That's what I really really really really care about. Here is the problem: ...
-2
votes
1answer
235 views

Cannot log-in in the install of phpmyadmin on Ubuntu

I just installed phpmyadmin and i am trying to login in /phpmyadminpath/setup. I am greeted by an invite similar to an apache protected folder (log/password displayed in a browser pop-up, not an html ...
0
votes
1answer
136 views

Connecting to external MySQL server from phpMyAdmin

How can I connect to external MySQL server to which I have granted access for my IP. What I have is: A website FTP link (like: ftp.domain.com) MySQL username and password Granted access to the ...
2
votes
1answer
6k views

Trying to install phpmyadmin on centos - mysqli missing

Here is the error I get when trying to open my phpmyadmin directory: phpMyAdmin - Error The mysqli extension is missing. Please check your PHP configuration. I have done the steps in the following ...
4
votes
1answer
11k views

How to upgrade to latest PHP, MySQL, and phpmyadmin on CentOS 5.8 (32bit)?

I have searched around on the internet and cannot find a reliable source for installing the latest versions of PHP, MySQL, and phpmyadmin on CentOS 5.8 32bit with apache. I have tried a couple times, ...
1
vote
1answer
295 views

PHP Configuration on IIS 6 Mysql extension is not loaded

I have limited knowledge of PHP. I would really appreciate your help. I have the problem with "PHPMyAdmin is not working because mysql extension is not loaded." I checked phpinfo and all other ...
0
votes
1answer
398 views

Configure phpMyAdmin to connect to another MySql server [closed]

I have installed WAMP server on my laptop and for the sake of simplicity I want to configure phpMyAdmin to connect to a mysql server on another machine so that I can dump the database tables. If this ...
1
vote
1answer
561 views

How to make my database accept external connections?

In my.cnf file I can find #bind-address = 127.0.0.1. Is changing it to bind-address = % will do the job?
0
votes
1answer
156 views

phpMyAdmin logs out when selecting database

I'm having an issue with pma whereby after logging in (as root or the database owner), and trying to switch to a certain database, I am automatically logged out. I cannot do any actions on the ...