0
votes
1answer
25 views

New MySQL 5.7 installation: Account “Any@%” with USAGE-only, no-GRANT? [duplicate]

I've a MySQL 5.7 brand-new installation (via Oracle official RPM) on CentOS 6.5. Via phpmyadmin, I see this strange "Any@%" account I didn't create, with only USAGE as GLOBAL PRIVILEGES and Grant: No ...
-1
votes
0answers
16 views

phpMyAdmin only shows first 10 databases of mySQL

I created databases in Cpanel with MySQL but when I go into phpMyAdmin it only shows the first 10 databases I created. How do I get phpMyAdmin to show all 12 of my databases?
-4
votes
2answers
30 views

MySQL incorrect result of insert [closed]

Created table 'testload' on demo database (int (15)) ...
0
votes
1answer
402 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
83 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
69 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
81 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
36 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 ...
1
vote
2answers
139 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
72 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
743 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
161 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
22 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
102 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
53 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
53 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
358 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
779 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
106 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
59 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
104 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
190 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
220 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
76 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
75 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
85 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
395 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
73 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
924 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
108 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
66 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
748 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
207 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
62 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
285 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
126 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
421 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
953 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
83 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
263 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
141 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
313 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
472 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
587 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?