Questions tagged [phpmyadmin]

phpMyAdmin is an open-source, web-based MySQL administration tool written in PHP. Use this tag for problems related to using this tool and not for general query problems

323
votes
67answers
1.1m views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through ...
145
votes
33answers
292k views

MySQL: Can't create table (errno: 150)

I am trying to import a .sql file and its failing on creating tables.Here's the query that fails:CREATE TABLE `data` (`id` int(10) unsigned NOT NULL,`name` varchar(100) NOT NULL,`value` varchar(...
2
votes
1answer
141 views

SQL statement is ignoring where parameter

SELECT * FROM people WHEREuniversity='2' AND MATCH (lname,fname) AGAINST ('+massive' IN BOOLEAN MODE) OR (fname LIKE '%box%' OR lname LIKE '%box%') This query is allowing results to filter ...
25
votes
17answers
314k views

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6Warning: ...
222
votes
17answers
218k views

MySQL Server has gone away when importing large sql file

I tried to import a large sql file through phpMyAdmin...But it kept showing error 'MySql server has gone away'What to do?
54
votes
18answers
135k views

How to display UTF-8 characters in phpMyAdmin?

I have my database properly set to UTF-8 and am dealing with a database containing Japanese characters. If I do SELECT *... from the mysql command line, I properly see the Japanese characters. When ...
66
votes
7answers
92k views

#1071 - Specified key was too long; max key length is 1000 bytes

I know questions with this title have been answered before, but please do read on. I've read thoroughly all the other questions/answers on this error before posting.I am getting the above error for ...
52
votes
10answers
253k views

Extension mysqli is missing, phpmyadmin doesn't work

I have a problem with phpmyadmin on ubuntu 12.04.I have already installed apache2, php5, mysql and phpmyadmin.The phpinfo(); script, don't show nothing about mysqli or mysql extension.When I try ...
123
votes
26answers
265k views

How to reset or change the MySQL root password?

How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql service before setting any changes? I have a phpmyadmin setup as well, will phpmyadmin get updated ...
293
votes
10answers
522k views

Setting up foreign keys in phpMyAdmin?

I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as ...
16
votes
5answers
39k views

MySQL : isn't in GROUP BY

The site produces results, but with SELECT COUNT and SELECT query with GROUP BY having two different result counts. This is likely due to the error that is displaying in phpmyadmin but not on the site....
20
votes
5answers
35k views

Subqueries with EXISTS vs IN - MySQL

Below two queries are subqueries. Both are the same and both works fine for me. But the problem is Method 1 query takes about 10 secs to execute while Method 2 query takes under 1 sec.I was able to ...
57
votes
10answers
125k views

How to write a stored procedure using phpmyadmin and how to use it through php?

I want to be able create stored procedures using phpMyAdmin and later on use it through php. But I dont know how to?From what I know, I found out that we cannot manage stored procedures through ...
46
votes
12answers
165k views

phpMyAdmin - can't connect - invalid setings - ever since I added a root password - locked out

I run XAMPP,a few days back i had set up a password for the root password through phpmyadminI am not able to access phpMyAdmin ever since that momentI followed help on this link but everything ...
40
votes
18answers
213k views

New xampp security concept: Access Forbidden Error 403 - Windows 7 - phpMyAdmin

I have downloaded and installed XAMPP 1.8.1 for Windows on Windows 7 Ultimate. I have set up XAMPP to run together with IIS as per these instructionsAll good so far, my PHP sites run locally and ...
2
votes
3answers
188 views

Mysql event error using php

I'm trying to initiate a MySQL Event using a PHP script. It works using phpMyAdmin (although I get the same error) but not using the script. I get the following error: You have an error in your ...
267
votes
26answers
707k views

Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know:upload_max_filesize, post_max_size.Why am I still seeing 2MB?Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.
202
votes
9answers
405k views

Find and Replace text in the entire table using a MySQL query

Usually I use manual find to replace text in a MySQL database using phpmyadmin. I'm tired of it now, how can I run a query to find and replace a text with new text in the entire table in phpmyadmin? ...
34
votes
9answers
35k views

Call to undefined function __() error - phpMyAdmin

When i want run phpMyAdmin on my browser, that show me this error:Fatal error: Call to undefined function __() in /usr/share/phpMyAdmin/libraries/core.lib.php on line 229Call Stack# Time ...
22
votes
2answers
13k views

Why is the estimated rows count very different in phpmyadmin results?

Without any changes on database I got very different rows count on my tables.What can cause this?Server version: 5.1.63-cllEngine: InnoDB
3
votes
4answers
10k views

Restore table structure from frm and ibd files

I am trying to restore a database in PMA but only have access to frm and ibd files - not the ib_log files which I understand you need.I know I may not be able to recover the database data but is it ...
113
votes
13answers
330k views

“Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP

I have just installed XAMPP on my Windows XP machine, and I get an error saying:Connection for controluser as defined in your configuration failed.Before I installed XAMPP, I had a MySQL ...
54
votes
15answers
284k views

Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave it a password of 'root'. This turned out to be a big mistake that I'm trying ...
40
votes
26answers
173k views

phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin

I have installed MySQL server enterprise 5.1 on my local machine and now I want to install phpMyAdmin, but it does not work.I have unrared phpMyAdmin to my server root directory and browsed to "...
33
votes
11answers
43k views

Is there a simple way to convert MySQL data into Title Case?

I have a MySQL table where all the data in one column was entered in UPPERCASE, but I need to convert in to Title Case, with recognition of "small words" akin to the Daring Fireball Title Case script....
52
votes
12answers
117k views

Resolution: This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available

This is not a question but a self generated problem/question and solution that I found working. I thought it would be decent courtesy to share since there was not a complete working solution I could ...
29
votes
2answers
147k views

Access denied for user 'root'@'localhost' with PHPMyAdmin

When I set the root password in PHPMyAdmin, I get this error:#1045 - Access denied for user 'root'@'localhost' (using password: NO)I can't open the PHPMyAdmin panel. What am I doing wrong?
23
votes
12answers
40k views

phpMyAdmin on MySQL 8.0

I have installed the MySQL 8.0 server and phpMyAdmin, but when I try to access it from the browser the following errors occur:#2054 - The server requested authentication method unknown to the client...
6
votes
6answers
11k views

Store procedures in phpMyAdmin

I must add stored procedures to MySQL database. The problem is that the hosting offers phpMyAdmin to manage the database. I searched on the Internet and the idea is to run the MySQL native ...
4
votes
1answer
10k views

Creating functions in phpMyAdmin - Error: access denied you need the super privilege for this operation

I imported a MySQL database. All the tables where successfully imported but not the functions. The only way I can execute SQL queries is through phpMyAdmin or with a PHP script (no SSH).Here's an ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,