Top "Mysql" questions

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

How can I restore the MySQL root user’s full privileges?

I accidentally removed some of the privileges from my MySQL root user, including the ability to alter tables. Is there …

mysql privileges mysql-error-1045
Using if(isset($_POST['submit'])) to not display echo when script is open is not working

I have a little problem with my if(isset($_POST['submit'])) code. What I want is some echos and a …

php mysql post if-statement isset
WHERE vs HAVING

Why do you need to place columns you create yourself (for example select 1 as "number") after HAVING and not WHERE …

mysql sql where-clause having-clause
Should MySQL have its timezone set to UTC?

Follow up question of https://serverfault.com/questions/191331/should-servers-have-their-timezone-set-to-gmt-utc Should the MySQL timezone be set to UTC or should it …

mysql time utc
Determine which MySQL configuration file is being used

Is there a command to determine which configuration file MySQL 5.0 is currently using?

mysql configuration
ERROR! MySQL manager or server PID file could not be found! QNAP

I am having an issue where MySQL isn't starting on my QNAP NAS. I found this first by not being …

mysql pid qnap
How to call a mysql stored procedure, with arguments, from command line?

How can I call a stored procedure from command line? I have a procedure: CREATE DEFINER=`root`@`localhost` PROCEDURE `insertEvent`(…

mysql command-line call procedure
mySQL Error 1040: Too Many Connection

How to fix these, "SQL Error 1040: Too Many Connection" even I try to put max_user_connection=500 still "Too many …

mysql connection
SQL order string as number

I have numbers saved as VARCHAR to a MySQL database. I can not make them INT due to some other …

mysql sql string numbers sql-order-by
What's faster, SELECT DISTINCT or GROUP BY in MySQL?

If I have a table CREATE TABLE users ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, profession …

mysql sql database group-by distinct