Mysql Error 1142 Create View
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: Why do create command denied to user for table I get "ERROR 1142 (42000): CREATE VIEW command denied
#1142 - Create Command Denied To User
to user..." New Topic Advanced Search Why do I get "ERROR 1142 (42000): CREATE mysql references command denied to user VIEW command denied to user..." Posted by: Greg Hauptmann () Date: August 31, 2008 02:00AM Hi, I can't figure out why I get the
Select Command Denied To User ''@'localhost' For Table 'user' Mysql
following error. When creating this user? > create user 'callagga'@'localhost' identified by 'password'; > grant all on myequity_production.* to 'callagga'@'localhost' identified by 'password' with grant option; > create view test_view as select * from transactions;ERROR 1142 (42000): CREATE VIEW command denied to user 'callagga'@'localhost' for table 'test_view'mysql> create command denied to user phpmyadmin Any ideas why? Note below in select * from db, all the fields are "Y" (i.e. doesn't this mean this user should have all privileges for this database). Some info: mysql> show grants; +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for callagga@localhost | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'callagga'@'localhost' IDENTIFIED BY PASSWORD '0f3d714d2e2a5422' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `myequity_production`.* TO 'callagga'@'localhost' WITH GRANT OPTION | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> select * from user where user = 'callagga'; +-----------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_sla
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow
Mysql Trigger Command Denied To User
the company Business Learn more about hiring developers or posting ads with us Stack
Drop Command Denied To User Mysql
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of sql error 1142 create command denied to user 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up CREATE command denied to user? up vote 9 down vote favorite 1 show grants for charm@'localhost'; ---------------------+ http://forums.mysql.com/read.php?10,224573 | Grants for charm@localhost | +-----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'charm'@'localhost' IDENTIFIED BY PASSWORD '*EDD1CD76B1331E363B2BAED3F0B7EAF28559FBEWD' | | GRANT ALL PRIVILEGES ON `charmstyle_com`.`charmstyle_com` TO 'charm'@'localhost' i used grant all on charmstyle_com to charm@'localhost' IDENTIFIED BY 't1q4gytrur'; flush privileges; then i import the database,it shows an error: ERROR 1142 (42000) at line 29: CREATE command denied to user 'charm'@'localhost' for table 'adminnotification_inbox' mysql share|improve this question asked Mar 27 '12 at 10:04 http://stackoverflow.com/questions/9887364/create-command-denied-to-user 37336792 881311 add a comment| 1 Answer 1 active oldest votes up vote 14 down vote accepted You granted the user permissions only to the 'charmstyle_com' table inside the 'charmstyle_com' database. What you probably want is to grant permissions to all the tables in 'charmstyle_com' (or at least the 'adminnotification_inbox' table) GRANT ALL PRIVILEGES ON `charmstyle_com`.* TO 'charm'@'localhost' alternatively GRANT ALL PRIVILEGES ON `charmstyle_com`.`adminnotification_inbox` TO 'charm'@'localhost' share|improve this answer answered Mar 27 '12 at 10:09 scibuff 7,96211620 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql or ask your own question. asked 4 years ago viewed 22414 times active 4 years ago Linked 0 How to user rails performance tests with real data Related 13mysql forgets who is logged in: command denied to user ''@'%'9update command is denied for user240MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)535How to import an SQL file using the command line in MySQL?0Create View command - Acce
here for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with http://www.webdesignforums.net/forum/database-systems-help/28204-create-command-denied-user.html us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just command denied like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error: #1142 - SELECT command denied to user up vote 13 down vote favorite 3 I'm having troubles with a certain query on one of my servers. On all other places I've tested it it works completely fine but on the command denied to server i want to use it it isn't working. It's about the following SQL: SELECT facturen.id AS fid, projecten.id AS pid, titel, facturen.totaal_bedrag AS totaal, betaald, datum FROM facturen, projecten WHERE facturen.project_id = projecten.id AND projecten.eigenaar = '1' ORDER BY datum DESC This is the error code I get from it: SELECT command denied to user 'marco'@'localhost' for table 'projecten' The tables: facturen: CREATE TABLE IF NOT EXISTS `facturen` ( `id` int(11) NOT NULL auto_increment, `project_id` int(11) NOT NULL, `datum` int(11) NOT NULL, `lever_datum` int(11) NOT NULL, `totaal_bedrag` decimal(9,2) NOT NULL, `btw` decimal(9,2) NOT NULL, `bedrijf` varchar(40) NOT NULL, `contactpersoon` varchar(60) NOT NULL, `adres` varchar(60) NOT NULL, `postcode` varchar(7) NOT NULL, `plaats` varchar(30) NOT NULL, `betaald` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=201200006 ; projecten: CREATE TABLE IF NOT EXISTS `projecten` ( `id` int(11) NOT NULL auto_increment, `titel` varchar(80) NOT NULL, `eigenaar` int(11) NOT NULL, `creatie_datum` int(11) NOT NULL, `eind_datum` int(11) NOT NULL, `totaal_bedrag` decimal(9,2) NOT NULL, `btw` decimal(9,2) NOT NULL, PRI
Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time. Remember Me? forgot password? Tweet Forum Programming and Development Help Database Systems Help CREATE command denied to user Results 1 to 4 of 4 Thread: CREATE command denied to user LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 04th, 2009,04:14 PM #1 Abstract Senior Member Join Date Aug 2003 Posts 194 Member # 2782 Hello friendly people, I am transferring one of my client's websites from my host to theirs. They are using GoDaddy's linux web hosting. As I have done with many other client's sites, I exported the data from the old database into a text file. Then I created a new database in their GoDaddy hosting account. In attempt to import the data, I receive the following error message: #1142 - CREATE command denied to user 'username'@'host' for table 'table_name' I am not experienced with MySQL so I had no idea what this meant; and I have never seen this error with other sites I have attempted to transfer either. So after some research on the net, I saw that I need to grant privileges to my user before performing any actions. :cross-eyed: - I have never had to "grant" privileges with any others users... so I found this a little weird. Any way, looking through PHPmyAdmin, I see there is another database that has a user_privileges table. What do I need to do to give myself permissions to perform actions with this database? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 04th, 200904:14 PM Web Design Forums Nov 04th, 2009,08:19 PM #2 smoseley WDF Staff Join Date Mar 2003 Location Boston, MA Posts 9,730 Member # 819Liked 200 times GRANT ALL on dbname.* to 'username'@'localhost' identified by 'password'; Share Share this post on Digg Del.icio.us Technorati Twitter Social Gift Idea Guide |