Top "Mysql" questions

Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

I have a version of phpMyAdmin located on my local Apache server. I am trying to login without a password …

php mysql apache passwords phpmyadmin

Dump a mysql database to a plaintext (CSV) backup from the command line

I'd like to avoid mysqldump since that outputs in a form that is only convenient for mysql to read. CSV …

mysql command-line csv backup

Force drop mysql bypassing foreign key constraint

I'm trying to delete all tables from a database except one, and I end up having the following error: Cannot …

mysql foreign-keys sql-drop

MySQL Results as comma separated list

I need to run a query like: SELECT p.id, p.name, (SELECT name FROM sites s WHERE s.id = …

sql mysql concatenation

mysql select from n last rows

I have a table with index (autoincrement) and integer value. The table is millions of rows long. How can I …

mysql select query-optimization

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 …

php mysql phpmyadmin wampserver

How to solve time out in phpmyadmin?

I want import huge (at least 300 mb) sql scripts via phpMyAdmin. I've tried: post_max_size = 750M upload_max_filesize = 750…

php mysql phpmyadmin execution-time

Preventing SQL injection in Node.js

Is it possible to prevent SQL injections in Node.js (preferably with a module) in the same way that PHP …

javascript mysql node.js sql-injection node-mysql

How to connect to mysql with laravel?

This is such a simple basic question I don't think there is much people asking this but simply how do …

php mysql laravel localhost

How to view table contents in Mysql Workbench GUI?

How can I view table contents in Mysql workbench GUI? I mean, not from command line.

mysql user-interface mysql-workbench