Home > command denied > error 1142 any command denied to user

Error 1142 Any Command Denied To User

Contents

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

Error 1142 42000 Select Command Denied To User

Learn more about Stack Overflow the company Business Learn more about hiring developers error 1142 42000 create command denied to user or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack error 1142 42000 select command denied to user localhost for table user Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up User cannot execute select error 1142 up vote

Error 1142 42000 Update Command Denied To User Localhost For Table User

3 down vote favorite My phpmyadmin or MySQL commandline will not let me execute the following query: SELECT customer.First, customer.Last, login.Username, login.Password, customer.Addrln1, customer.Addrln2, customer.Postcode, customer.County, customer.Country, customer.Phone, customer.Email, employee.EmpFirst, employee.EmpEmail, move.MoveID, move.CityOrig, move.CityDest, move.CountryOrig, move.CountryDest, move.EnquiryDate, move.Surveydate, move.QuoteDate, move.DepEst, move.DepAct, move.ArrEst, move.ArrAct, move.ClearEst, move.ClearAct, move.DelEst, move.DelAct, move.Port, move.Method, move.Status FROM customer LEFT JOIN oim2.login ON customer.CustID = login.CustID LEFT JOIN oim2.move ON customer.CustID = move.CustID LEFT

Syntax Error Or Access Violation 1142 Select Command Denied To User

JOIN oim2.employee ON move.EmpID = employee.EmpID WHERE customer.First = 'dave' and customer.Last='smith' 1142 - SELECT command denied to user 'oceanai3'@'localhost' for table 'login' Dave smith is just an example first and last name, the user can perform the following queries: SELECT * from login SELECT * FROM move SELECT * FROM customer If I remove the references to login out of the original query I then get the error #1142 - SELECT command denied to user 'oceanai3'@'localhost' for table 'move'. I have pastebin'd the full sql file of the db and it can be found here at: http://pastebin.com/H6aTS74m I have trawled through a lot of other peoples posts to find an answer but I couldnt find anything that helped me. Thanks C mysql phpmyadmin share|improve this question asked May 24 '12 at 8:55 Charlie 3923722 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted GRANT SELECT ON database.* TO user@'localhost' IDENTIFIED BY 'password'; Replace the placeholders with your values. share|improve this answer answered May 24 '12 at 8:58 Jivings 16.3k43172 #1044 - Access denied for user 'oceanai3'@'localhost' to database 'oceanai3_oim', the DB is on a shared server provided by justhost,

GroupBy Intersect Join OfType OrderBy Select Skip/Take Union Where C# ASP.NET Mail C# ASP.NET MVC Actions Controller Filters HTML Helpers Views C# ASP.NET 1142 insert command denied to user Reflection C# Collections and Generics C# Collections Examples C# File Handling

Mysql Any Command Denied To User

C# Flow Control C# Interoperability C# Network Programming C# Streams C# Streams Examples C# Threading C# XML select command denied to user ''@'localhost' for table 'user' mysql Cryptography Language Basics Object Oriented Concepts C# Csharp OOPS Examples Windows phone 7 Input Accelerometer FM Radio WPF .Net Controls C/C++ Arrays Control Structures Data Structures File http://stackoverflow.com/questions/10734176/user-cannot-execute-select-error-1142 access & processing Functions & Recursion Interview Questions Pointers User-Defined Data Types CSS CSS Basics Flash Actionscript Basics HTML Bootstrap HTML 5 HTML Basics XHTML Java Tutorials Android Development Android Http Services Collections Ext GWT (GXT) Java Data Types Java Language basics Network Programming Numbers & Dates Javascript ActiveX Ajax AngularJS Extjs Images and animations http://w3mentor.com/learn/mysql/mysql-errors/error-1142-42000-any-command-denied-to-user/ Javascript & CSS Javascript & DOM Javascript Events Jquery Language basics Object oriented Javascript Lessons ASP.NET Ajax JQuery Lessons Linux MYSQL MYSQL Administration MYSQL Basics MySql Errors MYSQL Functions MYSQL Interview Questions MYSQL Views Node.js Other Perl CGI Modules Perl Databases Perl Email Perl File Handling Perl Functions Perl Language Basics Perl Networking Perl string manipulation Perl Web Services Perl XML PHP/MySQL Tutorials CakePHP Codeigniter Language Basics For statement Functions IF/ELSE Statement Php Basics Examples Switch statement While statement Laravel MongoDB Object Oriented PHP Classes/Objects Constructor Php OOPS Examples PHP Arrays Php Arrays Examples PHP Cookies PHP Date and Time PHP Date Time Examples PHP Design patterns PHP File Handling File read PHP Flow Control PHP Forms Php Forms Examples PHP Graphics PHP Mail PHP MYSQL Php Mysql Examples PHP Regular Expressions PHP sessions PHP Web Services PHP XML PHP XML Examples Wordpress Zend Framework PL/SQL PL/SQL - Language Basics PLSQL Basics Examples PL/SQL - String Manipulation PL/SQL - XML PL/SQL Conversion PLSQL -

Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://serverfault.com/questions/597922/mysql-grant-command-denied-to-user-rootdhcp-x-x-x-x-company-for-table-t policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered https://forum.vestacp.com/viewtopic.php?t=10137 Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody command denied can ask a question Anybody can answer The best answers are voted up and rise to the top Mysql: GRANT command denied to user 'root'@'dhcp-x-x-x-x.' for table 'testtable' up vote 1 down vote favorite I am new to MySQL admin duties, and am trying to unsuccessfully grant SELECT Permissions to a limited number of columns in a table, using MySQL Workbench 5.2.44: command denied to GRANT SELECT (col1, col2, col3) ON mysqldb.testtable TO 'testuser'@'%' I get the following error: Error Code: 1142. GRANT command denied to user 'root'@'dhcp-x-x-x-x.companyname.com' for table 'testtable' I have gone through similar posts in here and have done the following tests: 1) SHOW GRANTS FOR 'root'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'xxxxxxxx' WITH GRANT OPTION GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION 2) SHOW GRANTS FOR 'root'@'%'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxxxxxxxx' GRANT ALL PRIVILEGES ON `mysqldb`.* TO 'root'@'%' 3) SHOW GRANTS FOR CURRENT_USER(); GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxxxxxxxx' GRANT ALL PRIVILEGES ON `mysqldb`.* TO 'root'@'%' 4) SELECT USER(), CURRENT_USER(); 'root@dhcp-x-x-x-x.companyname.com', 'root@%' 5) select host,user,select_priv, Create_user_priv from mysql.user; localhost root Y Y hostname.companyname.com root Y Y ::1 root Y Y % root Y Y Am I getting the 'GRANT command denied' error because even though I am root, CURRENT_USER() is identified as 'root'@'%' and GRANT ALL PRIVILEGES 'WITH GRANT OPTION' is only given to 'root'@'localhost' and therefore, 'root'@'%' is not evaluating to be the equivalent

regarding the Database ServerMySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin Post Reply Print view Search Advanced search 7 posts • Page 1 of 1 bam Posts: 2 Joined: Sat Dec 26, 2015 12:56 am Phpmyadmin cant open any table Quote Postby bam » Sat Dec 26, 2015 12:59 am when i try open any table on phpmyadmin i got error #1142 - SELECT command denied to user 'user'@'localhost' for table 'pma_table_uiprefs' on root #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist how to fix it ? ubuntu 15.04Happy Christmas and new year for all! Top BBuchanan1013 Posts: 97 Joined: Thu Jan 07, 2016 12:01 am Re: Phpmyadmin cant open any table Quote Postby BBuchanan1013 » Thu Jan 07, 2016 1:25 am bam wrote:when i try open any table on phpmyadmin i got error #1142 - SELECT command denied to user 'user'@'localhost' for table 'pma_table_uiprefs' on root #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist how to fix it ? ubuntu 15.04Happy Christmas and new year for all!It's a long drawn out process, but:https://wiki.phpmyadmin.net/pma/Configuration_storage Top neiklot Posts: 13 Joined: Tue Jan 19, 2016 9:56 am Re: Phpmyadmin cant open any table Quote Postby neiklot » Tue Jan 19, 2016 9:59 am Same problem here. I just installed debian 8 and vestacp, everything by default and when I create a new db and I create a new table using vestacp, this error happens.I can try to solve it but, does anyone know why is this happening? did i do something wrong or is this some vestacp issue?Thank you very much! Top neiklot Posts: 13 Joined: Tue Jan 19, 2016 9:56 am Re: Phpmyadmin cant open any tableTopic is solved Quote Postby neiklot » Tue Jan 19, 2016 10:30 am Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307 Top skurudo VestaCP Team Posts: 6116 Joined: Fri Dec 26, 2014 2:23 pm Location: Moscow Contact: Contact skurudo ICQ Website Facebook Google+ Skype Twitter YouTube Re: Phpmyadmin cant open any table Quote Postby skurudo » Tue Jan 19, 2016 1:31 pm neiklot wrote:Ok, I'll answer myself. Here is the solution: viewtopic.php?f=14&t=10307Yeah, it's my fix for all humankind. I tried to find all topics with this error and inform about the fix, but found not all :) -> DigitalOcean competition - please, support us-> fix for phpmyadmin - nice and sweet now Top shambhu123 Posts: 1 Joined: Wed Aug 03, 2016 3:30 am Re: Phpmyadmin cant open any table Quote Postby shambhu123 » Wed Aug 03, 2016 3:34 am Hi,Th

 

Related content

database error insert command denied to user

Database Error Insert Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Insert Command Denied To User Joomla a li li a href Insert Command Denied To User For Table a li li a href Insert Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings relatedl and policies of this site About Us Learn more about wordpress database error create command denied to user Stack

database returned error 1142 alter command denied to user

Database Returned Error Alter Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User localhost For Table user Mysql a li li a href Select Command Denied To User root localhost For Table user a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers relatedl to any questions you might have Meta Discuss the error select command denied to user workings and policies of this

error 1142 alter command denied to user

Error Alter Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Error Create Command Denied To User a li li a href Error Select Command Denied To User Localhost For Table User a li li a href Error Update Command Denied To User Localhost For Table User a li ul td tr tbody table p 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 relatedl About Us Learn more about Stack Overflow

error 1142 update command denied to user

Error Update Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Error Create Command Denied To User a li li a href Syntax Error Or Access Violation Select Command Denied To User a li li a href Mysql Update Command Denied To User a li li a href Update Command Denied To User localhost For Table a li ul td tr tbody table p 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

error 1142 drop command denied to user

Error Drop Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Error Update Command Denied To User Localhost For Table User a li li a href Select Command Denied To User localhost For Table a li li a href Select Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help relatedl Center Detailed answers to any questions you might error select command denied to user have Meta Discuss the workings and policies of this site error create command denied

error code 1142

Error Code table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Error a li li a href Mysql Error Insert Command Denied To User a li li a href Error Junos Pulse a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies relatedl of this site About Us Learn more about Stack Overflow the p h id Mysql Error Create

error no 1142 opencart

Error No Opencart table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User root localhost For Table user a li li a href Select Command Denied To User For Table proc a li li a href Select Command Denied To User For Column a li ul td tr tbody table p Download Documentation Documentation Screencasts Support General Support Community Forums Bug Tracker Contact relatedl Us Extensions Partners Community Forums Board index select command denied to user OpenCart Support Installation Upgrade Config Support Change font select command denied to user localhost

error no 1142 mysql

Error No Mysql table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Insert Command Denied To User a li li a href Mysql Error Code a li li a href Select Command Denied To User localhost For Table user Mysql a li ul td tr tbody table p here for a quick overview of the site relatedl Help Center Detailed answers to any questions mysql error create command denied to user you might have Meta Discuss the workings and policies of this p h id Mysql Error Insert Command Denied To User

failed with error code create command denied to user

Failed With Error Code Create Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Create Command Denied To User root localhost a li li a href Create View Command Denied To User a li ul td tr tbody table p 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 relatedl more about Stack Overflow the company Business Learn more about hiring developers wordpress database error create command denied to

failed with error code alter command denied to user

Failed With Error Code Alter Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Alter Routine Command Denied To User a li li a href Select Command Denied To User localhost For Table user Mysql a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might relatedl have Meta Discuss the workings and policies of this site alter command

joomla error number 1142

Joomla Error Number table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User a li li a href Mysql Error Create Command Denied To User a li li a href Error a li li a href Select Command Denied To User For Table proc a li ul td tr tbody table p Prices upgrade renewal - DemoAdditionnals - Templates pack - Custom template - Languages - Plugins relatedl - DownloadHelp - Faq - Videos - Documentation - p h id Select Command Denied To User p Change log - Forum

mysql 1142 error

Mysql Error table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Trigger Command Denied To User a li li a href Error a li li a href Select Command Denied To User For Table proc a li li a href Error Junos Pulse a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta relatedl Discuss the workings and policies of this site About Us mysql error create command denied to user Learn more about Stack Overflow

mysql database error any command denied to user

Mysql Database Error Any Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User localhost For Table a li li a href Select Command Denied To User For Table proc a li li a href Select Command Denied To User For Column a li li a href Select Command Denied To User Phpmyadmin a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to relatedl any questions you might have Meta Discuss the p h id

mysql administrator error 1142

Mysql Administrator Error table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error a li li a href Error Junos Pulse a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p here for a quick overview of the relatedl site Help Center Detailed answers to any select command denied to user localhost for table user mysql questions you might have Meta Discuss the workings and policies mysql error create command denied to user of this site About Us Learn more about Stack Overflow the

mysql create view error 1142

Mysql Create View Error table id toc tbody tr td div id toctitle Contents div ul li a href Create Command Denied To User For Table a li li a href Mysql References Command Denied To User a li li a href Mysql Error a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p Pelzer Email Updates Status Verified Impact on me None Category MySQL Server Security Privileges Severity S Non-critical Version -alpha-debug OS Linux SuSE Assigned to Assigned Account Triage Triaged D relatedl Medium View Add Comment Files Developer Edit

mysql error 1142 alter command denied

Mysql Error Alter Command Denied table id toc tbody tr td div id toctitle Contents div ul li a href Error a li li a href Trigger Command Denied To User a li li a href Grant All Privileges Mysql a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss relatedl the workings and policies of this site About Us Learn select command denied to user localhost for table more about Stack Overflow the company Business Learn more about hiring developers or

mysql error 1142 user

Mysql Error User table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Select Command Denied To User root localhost For Table user a li li a href Select Command Denied To User For Table proc a li li a href Mysql Error Insert Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions relatedl you might have Meta Discuss the workings and policies select command

mysql error 1142 any command denied to user

Mysql Error Any Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Select Command Denied To User root localhost For Table user a li li a href - Create Command Denied To User a li li a href Mysql Workbench Sql Error a li ul td tr tbody table p here for a quick overview of the site Help relatedl Center Detailed answers to any questions you might select command denied to user localhost for table have Meta

mysql error 1142 create view

Mysql Error Create View table id toc tbody tr td div id toctitle Contents div ul li a href - Create Command Denied To User a li li a href Select Command Denied To User localhost For Table user Mysql a li li a href Mysql Trigger Command Denied To User a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p Community Podcasts MySQL com Downloads Documentation Section Menu relatedl MySQL Forums Newbie Why do create command denied to user for table I get ERROR CREATE VIEW command denied p h

mysql error 1143

Mysql Error table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User root localhost For Table user a li li a href Select Command Denied To User localhost For Table user a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions relatedl you might have Meta Discuss the workings and show view command denied to user mysqldump policies of this site About Us Learn more about Stack Overflow the company mysql select command denied to user for

mysql error 1142

Mysql Error table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Select Command Denied To User root localhost For Table user a li li a href Mysql Error Insert Command Denied To User a li li a href Error Junos Pulse a li ul td tr tbody table p here for a quick overview of the site Help relatedl Center Detailed answers to any questions you might p h id Mysql Error Create Command Denied To User p have Meta Discuss the

mysql error code 1142

Mysql Error Code table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Mysql Trigger Command Denied To User a li li a href Error a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the relatedl workings and policies of this site About Us Learn more select command denied to user localhost for table user mysql about Stack Overflow the company Business Learn more

mysql error 1142 select command denied

Mysql Error Select Command Denied table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User root localhost For Table user a li li a href Select Command Denied To User For Table proc a li li a href Mysql Error Insert Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies relatedl of this site About Us Learn more about Stack Overflow select command

mysql error 1142 update command denied to user

Mysql Error Update Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Drop Command Denied To User Mysql a li li a href Wordpress Database Error Insert Update Command Denied To User a li li a href Trigger Command Denied To User a li ul td tr tbody table p 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 relatedl Learn more about Stack Overflow the company Business Learn more

mysql error code 1142 sqlstate 42000

Mysql Error Code Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Trigger Command Denied To User a li li a href Mysql References Command Denied To User a li li a href Error Update Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta relatedl Discuss the workings and policies of this site About mysql error create command denied to user Us Learn more about Stack Overflow the company Business

mysql error number 1142

Mysql Error Number table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User localhost For Table user Mysql a li li a href Mysql Trigger Command Denied To User a li li a href Select Command Denied To User root localhost For Table user a li li a href Select Command Denied To User For Table proc a li ul td tr tbody table p here for a quick overview of the site Help relatedl Center Detailed answers to any questions you might p h id Select Command Denied To

mysql query failed with error 1142

Mysql Query Failed With Error table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User localhost For Table user Mysql a li li a href Mysql Trigger Command Denied To User a li li a href Select Command Denied To User For Table proc a li li a href Error Junos Pulse a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any relatedl questions you might have Meta Discuss the workings p h id Select Command Denied To

mysql error code 1142. select command denied to user

Mysql Error Code Select Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User For Table proc a li li a href Mysql Error Create Command Denied To User a li li a href Error Select Command Denied To User Localhost For Table User a li li a href Drop Command Denied To User Mysql a li ul td tr tbody table p here for a quick overview of the site Help relatedl Center Detailed answers to any questions you might select command denied to user

mysqli statement execute error any command denied to user

Mysqli Statement Execute Error Any Command Denied To User table id toc tbody tr td div id toctitle Contents div ul li a href Select Command Denied To User localhost For Table a li li a href Insert Command Denied To User a li li a href Mysql Execute Privilege a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings relatedl and policies of this site About Us Learn more about execute command denied to user for routine Stack Overflow

mysql sql error 1142 sqlstate 42000

Mysql Sql Error Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Workbench Sql Error a li li a href Mysql Trigger Command Denied To User a li li a href Mysql References Command Denied To User a li ul td tr tbody table p 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 relatedl site About Us Learn more about Stack Overflow the company Business mysql error create command denied to user Learn more

mysql error no 1142

Mysql Error No table id toc tbody tr td div id toctitle Contents div ul li a href Mysql Error Create Command Denied To User a li li a href Error a li li a href Mysql Error Insert Command Denied To User a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you relatedl might have Meta Discuss the workings and policies of this select command denied to user localhost for table user mysql site About Us Learn more about Stack Overflow the company Business Learn