Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

"Connect failed: Access denied for user 'root'@'localhost' (using password: YES)" from php function

I wrote some function used by a php webpage, in order to interact with a mysql database. When I test …

php mysql access-denied
What's the difference between VARCHAR and CHAR?

What's the difference between VARCHAR and CHAR in MySQL? I am trying to store MD5 hashes.

sql mysql
Finding duplicate values in MySQL

I have a table with a varchar column, and I would like to find all the records that have duplicate …

mysql
Cast from VARCHAR to INT - MySQL

My Current Data for SELECT PROD_CODE FROM `PRODUCT` is PROD_CODE 2 5 7 8 22 10 9 11 I have tried all the four queries and …

mysql sql
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 …

mysql phpmyadmin
Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction

I'm running the following MySQL UPDATE statement: mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout …

mysql sql timeout lock-timeout
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty …

java mysql jdbc
SQL - Update multiple records in one query

I have table - config. Schema: config_name | config_value And I would like to update multiple records in one …

mysql record
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I'm setting up a new server and keep running into this problem. When I try to login to the MySQL …

mysql iredmail