By looking at this thread here, it looks like you might be using the shell in js mode, you might be able to toggle it off by using the switch

    \sql 

https://forums.mysql.com/read.php?10,661192,661203#msg-661203

You can type:

    Mysql JS&gt;  \sql
    Mysql SQL&gt;  \connect root@localhost

and provide your password.


Logging in as follows *did* work as shown by Rahul in another answer:

    Mysql JS&gt;  \sql
    Mysql SQL&gt;  \connect root@localhost

However, I was able to get `Mysql&gt;` instead of `Mysql JS&gt;` or `Mysql SQL&gt;` by opening the Windows command prompt and entering the following:

    mysql -u root -p

try using 
**connect root@localhost**
and then try
**\sql** 
to switch to sql mode if the default mode is JS.

After using \connect root@localhost code, I am still getting the following error, even after putting in my password:
MySQL Error 2003 (HY000): Can&#39;t connect to MySQL server on &#39;localhost:3306&#39; (10061)

As the title says, would it be possible for eslint to show warnings instead of errors on ALL of the rules? I&#39;m using Standard JS, if that information is relevant. 

Thanks!

Is it possible to show warnings instead of errors on ALL of eslint rules?

I have 2 columns in table servers.

I have columns `ip` and `hostname`.

I have validation:

    &#39;data.ip&#39; =&gt; [&#39;required&#39;, &#39;unique:servers,ip,&#39;.$this-&gt;id]

This working only for column `ip`. But how to do that it would work and for column `hostname`? 

I want validate data.ip with columns `ip` and `hostname`.
Because can be duplicates in columns ip and hostname, when user write ip.

Laravel unique validation on multiple columns

I just installed MySQL on my computer and when I try to create a database from the MySQL shell, I get this error:

    MySQL  JS &gt; CREATE DATABASE databasename;
    SyntaxError: Unexpected identifier

Does anyone know why this is happening? Is there a problem with the installation of MySQL?

MySQL: SyntaxError: Unexpected identifier

I just installed MySQL on my computer and when I try to create a database from the MySQL shell, I get this error:
<pre><code class="hljs language-ini">MySQL JS > CREATE DATABASE databasename;
SyntaxError: Unexpected identifier
</code></pre>
Does anyone know why this is happening? Is there a problem with the installation of MySQL?

I have a WordPress production website.

I&#39;ve exported the database by the following commands: `select database &gt; export &gt; custom &gt; select all tables &gt; select .zip compression &gt; &#39;Go&#39;`

I&#39;ve downloaded the file which is example.sql.zip but when I upload to my localhost I get this error: `phpMyAdmin - Error &gt; Incorrect format parameter`

I&#39;ve tried to export with other formats and I get the same error.

I&#39;ve tried with other SQL Databases and it exports/ imports just fine.

What could it be? A corrupt database or other?

Thanks

phpMyAdmin - Error &gt; Incorrect format parameter?

I have actually lost my root password and I need to change it.  I follow these steps :

 - Step # 1: Stop the MySQL server process.
   
   Step # 2: Start the MySQL (mysqld) server/daemon process with the
   --skip-grant-tables option so that it will not prompt for a password.
   
   Step # 3: Connect to the MySQL server as the root user.

that we can found on these website : https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords#recover-mysql-root-password

    mysql&gt; use mysql;
    mysql&gt; SET PASSWORD FOR &#39;root&#39;@&#39;localhost&#39; = PASSWORD(&quot;TOOR&quot;);
    mysql&gt; flush privileges;
    mysql&gt; quit

First error, so I tried :

    mysql&gt; use mysql;
    mysql&gt; update user set password=PASSWORD(&quot;TOOR&quot;) where User=&#39;root&#39;;
    mysql&gt; flush privileges;
    mysql&gt; quit

Always the same error said : 

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near &#39;(&quot;TOO
    R&quot;) WHERE User=&#39;root&#39;&#39; at line 1

How can I resolve this?


How to reset the root password in MySQL 8.0.11?

I am trying to export my database from MySQL Workbench but I get this during the export progress:

&gt; Running: mysqldump.exe
&gt; --defaults-file=&quot;c:\users\user\appdata\local\temp\tmp2h91wa.cnf&quot;  --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers &quot;mydb&quot; mysqldump: Couldn&#39;t execute &#39;SELECT COLUMN_NAME,                      
&gt; JSON_EXTRACT(HISTOGRAM, &#39;$.&quot;number-of-buckets-specified&quot;&#39;)            
&gt; FROM information_schema.COLUMN_STATISTICS                WHERE
&gt; SCHEMA_NAME = &#39;mydb&#39; AND TABLE_NAME = &#39;courses&#39;;&#39;: Unknown table
&gt; &#39;column_statistics&#39; in information_schema (1109)
&gt; 
&gt; Operation failed with exitcode 2 20:55:09 Export of
&gt; C:\Users\user\Documents\dumps\mydb.sql has finished with 1 errors

Can&#39;t export my database from mysql workbench

I&#39;m trying to pull out all my Identity users and their associated roles for a user management admin page. I thought this would be reasonably easy but apparently not. I&#39;ve tried following the following solution: https://stackoverflow.com/a/43562544/5392786 but it hasn&#39;t worked out so far.

Here is what I have so far:

**ApplicationUser:**

    public class ApplicationUser : IdentityUser
    {
        public List&lt;IdentityUserRole&lt;string&gt;&gt; Roles { get; set; }
    }

**DBContext**

    public class ApplicationDbContext : IdentityDbContext&lt;ApplicationUser&gt;
    {
        public ApplicationDbContext(DbContextOptions&lt;ApplicationDbContext&gt; options)
            : base(options)
        {
        }
    }

**Startup Identity code**

    services.AddIdentity&lt;ApplicationUser, IdentityRole&gt;(options =&gt; options.Stores.MaxLengthForKeys = 128)
                .AddEntityFrameworkStores&lt;ApplicationDbContext&gt;()
                .AddDefaultTokenProviders();

**Razor Page where I want to display the list:**

    public class IndexModel : PageModel
    {
        private readonly UserManager&lt;ApplicationUser&gt; userManager;

        public IndexModel(UserManager&lt;ApplicationUser&gt; userManager)
        {
            this.userManager = userManager;
        }

        public IEnumerable&lt;ApplicationUser&gt; Users { get; set; }

        public void OnGetAsync()
        {
            this.Users = userManager.Users.Include(u =&gt; u.Roles).ToList();
        }
    }

I get the following error when calling `userManager.Users.Include(u =&gt; u.Roles).ToList();`:

&gt; MySql.Data.MySqlClient.MySqlException: &#39;Unknown column &#39;u.Roles.ApplicationUserId&#39; in &#39;field list&#39;&#39;


.NET Core 2.1 Identity get all users with their associated roles

I just installed mysql on mac from Homebrew 

    brew install mysql
    
    mysql -V

    mysql  Ver 8.0.11 for osx10.13 on x86_64 (Homebrew)

from terminal it works and I can login to mysql but from Sequel Pro it says

[![enter image description here][1]][1]

&gt; Unable to connect to host 127.0.0.1, or the request timed out.
&gt; 
&gt; Be sure that the address is correct and that you have the necessary
&gt; privileges, or try increasing the connection timeout (currently 10
&gt; seconds).
&gt; 
&gt; MySQL said: Authentication plugin &#39;caching_sha2_password&#39; cannot be
&gt; loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2):
&gt; image not found

can&#39;t figure out what I am missing


  [1]: https://i.stack.imgur.com/CIJGy.png

Sequel Pro and MySQL connection failed

I was trying to delete PostgreSQL user:

    DROP USER ryan;

I received this error:

&gt;     Error in query:
&gt;     ERROR: role &quot;ryan&quot; cannot be dropped because some objects depend on it
&gt;     DETAIL: privileges for database mydatabase

I looked for a solution from these threads:

 - https://stackoverflow.com/questions/3023583/postgresql-how-to-quickly-drop-a-user-with-existing-privileges
 - https://stackoverflow.com/questions/32988702/how-to-drop-user-in-postgres-if-it-has-depending-objects

Still have the same error.

This happens after I grant all permission to user &quot;ryan&quot; with:

    GRANT ALL PRIVILEGES ON DATABASE mydatabase ON SCHEMA public TO ryan;

Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

Here is this issue:
I attempt to install mysqlclient like so

    C:\Users\amccommon349&gt;pip install mysqlclient
    Collecting mysqlclient
      Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1
    cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz
    Installing collected packages: mysqlclient
      Running setup.py install for mysqlclient ... error
        Complete output from command c:\users\amccommon349\appdata\local\programs\python\python36\python.exe -u -c &quot;import setuptools, tokenize;__file__=&#39;C:\\Users\\AMCCOM~1\\AppData\\Local\\Temp\\pip-install-qcgo48hf\\mysqlclient\\setup.py&#39;;f=getattr(tokenize, &#39;open&#39;, open)(__file__);code=f.read().replace(&#39;\r\n&#39;, &#39;\n&#39;);f.close();exec(compile(code, __file__, &#39;exec&#39;))&quot; install --record C:\Users\AMCCOM~1\AppData\Local\Temp\pip-record-q4yoftj8\install-record.txt --single-version-externally-managed --compile:

    c:\users\amccommon349\appdata\local\programs\python\python36\lib\distutils\dist.py:261: UserWarning: Unknown distribution option: &#39;long_description_content_type&#39;
    warnings.warn(msg)
    running install
    running build
    running build_py
    creating build
    creating build\lib.win-amd64-3.6
    copying _mysql_exceptions.py -&gt; build\lib.win-amd64-3.6
    creating build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\__init__.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\compat.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\connections.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\converters.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\cursors.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\release.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    copying MySQLdb\times.py -&gt; build\lib.win-amd64-3.6\MySQLdb
    creating build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\__init__.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\CLIENT.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\CR.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\ER.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\FIELD_TYPE.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\FLAG.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    copying MySQLdb\constants\REFRESH.py -&gt; build\lib.win-amd64-3.6\MySQLdb\constants
    running build_ext
    building &#39;_mysql&#39; extension
    creating build\temp.win-amd64-3.6
    creating build\temp.win-amd64-3.6\Release
    C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\bin\HostX86\x64\cl.exe /c/nologo/Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,3,13,&#39;final&#39;,0) -D__version__=1.3.13 &quot;-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.1\include&quot; -Ic:\users\amccommon349\appdata\local\programs\python\python36\include -Ic:\users\amccommon349\appdata\local\programs\python\python36\include &quot;-IC:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\include&quot; &quot;-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um&quot; &quot;-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\ucrt&quot; &quot;-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\shared&quot; &quot;-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\um&quot; &quot;-IC:\ProgramFiles (x86)\Windows Kits\10\include\10.0.17134.0\winrt&quot; &quot;-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\cppwinrt&quot; /Tc_mysql.c /Fobuild\temp.win-amd64-3.6\Release\_mysql.obj /Zl _mysql.c
    _mysql.c(29): fatal error C1083: Cannot open include file: &#39;mysql.h&#39;: No such file or directory
      error: command &#39;C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.14.26428\\bin\\HostX86\\x64\\cl.exe&#39; failed with exit status 2

I made sure I had all of the files needed from visual studios build tools, I downloaded the mysql-python connector, and updated my pip and setup tools. I am a complete beginner to this and would appreciate any input as to how to go about fixing this error.


pip install mysqlclient returns &quot;fatal error C1083: Cannot open file: &#39;mysql.h&#39;: No such file or directory

 For the following code:

    DECLARE @ss varchar(60)
      SET @ss = &#39;admin&#39;
    
      select TRIM(@ss)

I&#39;ve got an error: 
&gt; &#39;TRIM&#39; is not a recognized built-in function name


  

TRIM is not a recognized built-in function name

* If you execute `SELECT -100/-100*10` the result is `0`.
* If you execute `SELECT (-100/-100)*10` the result is `10`.
* If you execute `SELECT -100/(-100*10)` the result is `0`.
* If you execute `SELECT 100/100*10` the result is `10`.

[BOL](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operator-precedence-transact-sql?view=sql-server-2017) states:

&gt; When two operators in an expression have the same operator precedence level, they are evaluated left to right based on their position in the expression.

And

    Level	Operators
      1  	~ (Bitwise NOT)
      2 	* (Multiplication), / (Division), % (Modulus)
      3 	+ (Positive), - (Negative), + (Addition), + (Concatenation), - (Subtraction), &amp; (Bitwise AND), ^ (Bitwise Exclusive OR), | (Bitwise OR)

Is BOL wrong, or am I missing something? It seems the `-` is throwing the (expected) precedence off.

A strange operation problem in SQL Server: -100/-100*10 = 0

I have a field which is a varchar(20)

When this query is executed, it is fast (Uses index seek):

    SELECT * FROM [dbo].[phone] WHERE phone = &#39;5554474477&#39;

But this one is slow (uses index scan).

    SELECT * FROM [dbo].[phone] WHERE phone = N&#39;5554474477&#39;

I am guessing that if I change the field to an nvarchar, then it would use the Index Seek.

Content Type	Original Author	Original Content on Stackoverflow
Question	Slaknation	View Question on Stackoverflow
Solution 1 - Mysql	Max Carroll	View Answer on Stackoverflow
Solution 2 - Mysql	Rahul Prasad	View Answer on Stackoverflow
Solution 3 - Mysql	Melanie Shebel	View Answer on Stackoverflow
Solution 4 - Mysql	Hari Ravi	View Answer on Stackoverflow
Solution 5 - Mysql	Aryan Srivastava	View Answer on Stackoverflow

MySQL: SyntaxError: Unexpected identifier

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Laravel unique validation on multiple columns

Is it possible to show warnings instead of errors on ALL of eslint rules?

Attributions