[DiscordArchive] Did you input it actually to mysql?
[DiscordArchive] Did you input it actually to mysql?
Archived author: Rymercyble • Posted: 2023-03-09T21:18:12.238000+00:00
Original source
ye remove it i checked it counts it as name of DB
Archived author: Revision • Posted: 2023-03-09T21:18:21.099000+00:00
Original source
if you wanted to include the password in the command btw, you have to input -ppassword (without the space)
Archived author: Scortas • Posted: 2023-03-09T21:18:37.305000+00:00
Original source
ohh
Archived author: Scortas • Posted: 2023-03-09T21:19:00.958000+00:00
Original source
lauri@lauri-Lenovo-IdeaPad-Y510P:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
lauri@lauri-Lenovo-IdeaPad-Y510P:~$ mysql -u root -ppassword
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Archived author: Revision • Posted: 2023-03-09T21:19:02.947000+00:00
Original source
I don't know why since the user doesn't need that but it is what it is
Archived author: Revision • Posted: 2023-03-09T21:19:20.530000+00:00
Original source
That's strange
Archived author: Revision • Posted: 2023-03-09T21:19:51.603000+00:00
Original source
Is the password for root actually *password*?
Archived author: Rymercyble • Posted: 2023-03-09T21:20:01.740000+00:00
Original source
then that query was not successful or ran at all
Archived author: Rymercyble • Posted: 2023-03-09T21:20:20.552000+00:00
Original source
or u changed password to different password than password
Archived author: Scortas • Posted: 2023-03-09T21:21:01.305000+00:00
Original source
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
I ran this