Top "Mysql-error-1142" questions

MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' …

mysql mariadb mysql-error-1142

Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'

In my website, I am using MySQL database. I am using a webservice where in I do all my database …

mysql mysqldatareader mysql-error-1142

CREATE command denied to user？

show grants for charm@'localhost'; ---------------------+ | Grants for charm@localhost | +-----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'charm'@'localhost' IDENTIFIED BY PASSWORD …

mysql mysql-error-1142

CREATE command denied for user that has GRANT ALL PRIVILEGES

I am trying to set up a MySQL replication slave, and am having a very difficult time running LOAD DATA …

mysql mysql-error-1142

MySQL: ERROR 1142 (42000) and ERROR 1064 (42000)

I'm using windows 7. I've downloaded mysql-5.5.16-win32.zip and installed it. I started MySQL server successfully, but I get this …

mysql mysql-error-1064 mysql-error-1142

GRANT DELETE ON database.table TO username@'%';

I have given a user full control over one table in a database. Hoever it appears they cant delete records. …

mysql mysql-error-1142

Error 1142: SELECT and LOCK TABLE commands denied

I reinstalled the server running MySQL. I had created a backup of the database by using MySQL Workbench. Now I'm …

mysql mysqldump mysql-workbench mysql-error-1142

Is there a better way to assign permissions to temporary tables in MySQL?

Our users log into the production database as a fairly low-level user, with SELECT granted at the database level, and …

mysql mysql-error-1146 mysql-error-1142