Top "Mysql" questions

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

MySQL JDBC Driver 5.1.33 - Time Zone Issue

Some background: I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC …

java mysql tomcat jdbc timezone
ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user …

mysql mysql-management
How do I retrieve my MySQL username and password?

I lost my MySQL username and password. How do I retrieve it?

mysql
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked …

php mysql windows phpmyadmin passwords
How do I add indices to MySQL tables?

I've got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM …

mysql optimization indexing row
difference between primary key and unique key

I'm using mysql database. I have a confusion between primary key and unique key. Please help me where should I …

mysql sql database primary-key unique-key
How to export and import a .sql file from command line with options?

Not Duplicate! looking for some feature have phpmyadmin during export in command line I want to export and import a .…

mysql command-line command-line-arguments sqlcommand
Passing an array to a query using a WHERE clause

Given an array of ids $galleries = array(1,2,5) I want to have a SQL query that uses the values of the …

php mysql arrays
Access denied for user 'test'@'localhost' (using password: YES) except root user

I am facing problem with mysql non root/admin user, I am following the below steps for creating user and …

mysql mysql-error-1045
Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

I know this question was asked a lot before but I tried some of the solutions which were given and …

mysql database localhost mysql-workbench windows-7-x64