mysql-error-1142 Questions
18
Solved
In my website, I am using MySQL database. I am using a webservice where in I do all my database related manipulations.
Now In one of the methods of that webservice, I get the following Error.
sele...
Yeoman asked 22/1, 2011 at 9:13
2
Solved
I have given a user full control over one table in a database. Hoever it appears they cant delete records.
I've tried as a privilaged user:
GRANT DELETE ON databasename.tablename TO username@'%';...
Ausgleich asked 8/10, 2010 at 15:8
11
Solved
I've created database, for example 'mydb'.
CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH';
GRANT ALL ON mydb.* TO 'myuser'@'%';
...
Resnick asked 16/2, 2011 at 12:38
4
Solved
I am trying to set up a MySQL replication slave, and am having a very difficult time running LOAD DATA FROM MASTER;. Yes, I know it is deprecated, but I am running MySQL 5.1, and that isn't my prob...
Tramel asked 10/3, 2011 at 1:49
1
Solved
show grants for charm@'localhost';
---------------------+
| Grants for charm@localhost |
+----------------------------------------------------------------------------------------------------------...
Tashia asked 27/3, 2012 at 10:4
3
Solved
Our users log into the production database as a fairly low-level user, with SELECT granted at the database level, and INSERT/UPDATE/DELETE granted on the specific tables they need access to.
They ...
Pisano asked 10/12, 2009 at 11:48
2
Solved
I am trying to port some data over from my production database to my sandbox using a query like this:
INSERT `dbsandbox`.`SomeTable`(Field1, Field2, Field3)
SELECT t.Field1, t.Field2, t.Field3
FRO...
Pontormo asked 3/12, 2008 at 18:36
1
© 2022 - 2024 — McMap. All rights reserved.