Run MySQL Database Queries From VS Code | MySQL installation

MySQL installation and Connecting MySQL database to VS Code

CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'sqluser'@'%';
FLUSH PRIVILEGES;

#mysql #vscode #installation

[anuragchauhan]

Thanks man ! after hours of struggle it finally worked.

[abhinavtripathi]

Thanks man I was struggling since yesterday...

[harshitasharma]

At 5:13 it shows
C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MYSQL --version
'MYSQL' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>mysql --version
'mysql' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>

[sachinppatel]

Hi,

i am getting this error for creating connection "ER_BAD_DB_ERROR: Unknown database 'mydb'" . pls help.

[harshitasharma]

I am facing issues in connecting it displays some error and i am unable to remove them i need help .

[vaishnevishethe]

I am getting this after 'test connection'

Error opening connection ER_BAD_DB_ERROR: Unknown database 'test_db'

[harshitasharma]

It took my whole day and i am still unable to do it.

[harshitasharma]

At 5:49 Users\harsh>mysql -version
'mysql' is not recognized as an internal or external command,
operable program or batch file.

[sankalpnaik]

Error opening connection ER_ACCESS_DENIED_ERROR: Access denied for user 'sankalp'@'localhost' (using password: YES)

[supratiksarkar]

My is 64 bit. So I downloaded it and now it shows error in password.

[-PavanSingh]

mysql for visual studio is not shown
anyone with solution?

[trisharoychowdhury]

Please say, what is the password during the connection???

[cristian]

Non ho capito quale password devo mettere?

[luffy]

'-u' is not recognized as an internal or external command,
operable program or batch file.

[michaeltillcock]

it works right until the end - then show DATABASES; does not work - says a console error - and while you can see databases under mysql, i cannot...? (subscribed cos you got me 90% there)

[sajadmehrizi]

It doesn't work! Request connection/Get error

[riju]

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

problem

[ritikraj]

Bro when i click Run on active connection then it throws the error please help me
Request failed with message: Unknown database 'myshop'...
Bro please help me all thing I did correctly at last it stuck please😢😢😭😭

[ReyhanDelaMasyhuri]

mysql> GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';
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 '. TO 'sqluser'@'%'' at line 1