Reset to default
Trending sort is based off of the default sorting method — by highest score — but it boosts votes that have happened recently, helping to surface more up-to-date answers.
It falls back to sorting by highest score if no posts are trending.
for some reason, the ODBC user is the default username under windows even if you didn’t create that user at setup time. simply typing
without specifying a username will attempt to connect with the non-existent ODBC username, and give:
Error 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO)
Instead, try specifying a username that you know, for example:
mysql -u root -p
-u root specified the username
-p will make the command prompt for a password.
You need to create an user “ODBC” for MySql with no password. Do that in PHPMyAdmin. That will solve your problem.
But remember, if it’s only your local development environment, no problem. It’ll create a serious security hole in your production environment.
I tried this and it worked:
C:\cd MySQL installed path\MySQL -uyourusername -pyourpassword
C:\Users\abhay kumar>mysql --user=admin --password=root..
This command is working for root user..you can access mysql tool from any where using command prompt..
C:\Users\lelaprasad>mysql --user=root --password=root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.5.47 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
I know it’s been three years since this was asked, but I just figured out this problem for myself. I was using
into outfile and getting the error. When I commented out this part of the query, it worked.
FILE privilege is separate from all the others and must be granted to the user running the script.
GRANT FILE ON *.* TO 'asdfsdf'@'localhost';
Just create a file my.ini file in installation dir and have the below config as part of this file to solve this permanently.
[mysql] user=root password=root
Try using following command it work.
mysql --user=root --password=root_password
Why you can’t just use mysqlsh?
PS C:\Users\artur\Desktop> mysqlsh --user root MySQL Shell 8.0.17 Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. Creating a session to '[email protected]' Fetching schema names for autocompletion... Press ^C to stop. Your MySQL connection id is 13 (X protocol) Server version: 8.0.17 MySQL Community Server - GPL No default schema selected; type \use <schema> to set one. MySQL localhost:33060+ ssl JS >
Try this command:
mysql -uroot -p
then it will ask for password
root as the password.
- open command line (run as admin)
- go into Mysql server bin folder
- run command:
mysqldump -u root -p mydbscheme > mydbscheme_dump.sql
- give your password here against root.
It will work perfect !!
You can create user with no password in phpmyadmin and it solves the problem!
It seems like You haven’t set the Mysql server path, Set Environment Variable For MySql Server. Then restart the command prompt and enter mysql -u root-p then it asks for a password enter it.
You can connect to SQL from a python Jupiter notebook using this syntax:
import mysql.connector as conn conn.connect(host="localhost", user="root", passwd = 'xxx')
xxx = your password for MySQL
user = your MySQL user name, which might be different from
root. Check your MySQL
userid, and change it accordingly.
i entered in Mysql Workbench and i changed the password. It seem the password was expired. it works!
I encountered this problem today. I tried
mysql -u root -p, but it doesn’t work.
I restarted the mysql service by two commands:
net stop mysql and
net start mysql
then tried the command
mysql. It worked.