Skip to main content

MySQL Command Line - Newbies Errors

 Newbies Errors when using MySQL Command Line Client (CLI)

1. Path

This will give an error:


This is actually correct:


* Notice the "/" and "\".

2. Exiting error

So when I got the error from the above:


I didn't know how to exit. 

To exit,
            "From a bash shell you could just type ctrl-c and get a new prompt. In"

3. Connection with Go

I'm working on Go at the moment. And the following is the tutorial I'm following: https://go.dev/doc/tutorial/database-access

When I tried running "go run .", I received the following error:


I tried:

a) Added a new user that is NOT "root" - same error

b) Added the parameter "AllowNativePasswords: true":


And was finally seeing a different error:


So it seems like the DBUSER and DBPASS that I've set based on the steps weren't saved...

I wasn't able to find the reason why it's not working.. So instead of handling it in the command, the following is what I did to make it work:


Again, this is solely for tutorial since I'd like to move to the next step and SHOULD NOT be done in actual coding environment. This works, for tutorial purposes.

I will update once I found the actual solution. :-)







Comments

Post a Comment

Popular posts from this blog

VS 2022 / .Net Core Error : Node.js is required to build and run this project. To continue, please install Node.js from https://nodejs.org/, and then restart your command prompt or IDE.

I just created a new .Net Core 3.1 project. I installed Node.JS (from Nuget Packages). I've also used the VS installer to install Node.JS. But when I run, I was still having the issue below error : Node.js is required to build and run this project. To continue, please install Node.js from https://nodejs.org/, and then restart your command prompt or IDE. I was running Visual Studio 2022. What solved it was the following: 1) I searched for node.exe and found it at the following folder: C:\Program Files\Microsoft Visual Studio\2022\Enterprise\MSBuild\Microsoft\VisualStudio\NodeJs 2) Opened Windows Start Menu and typed "Edit the system environment variables" 3) Click on "Environment Variables" 4) At the next screen, look for "Path" under "System Variables". Double click it / click edit. 5) Add the nodejs path from (1). 6) Restart visual studio and taraa. Solution was from one of the answers in:  https://stackoverflow.com/questions/59115525/node-j...
Post a Comment
Read more

VS Code / Flutter: Error "'flutter' is not recognized as the name of a cmdlet..."

 I was trying to run a command: flutter pub add youtube_player_flutter But it was giving me the error: "'flutter' is not recognized as the name of a cmdlet..." To fix this, we need to add it to the Environment Variables (just like what I did for node.js in the previous post!) 1) You should know where's your flutter's sdk at this point. Mine is at: C:\src\flutter\bin 2) Opened Windows Start Menu and typed "Edit the system environment variables" 3) Click on "Environment Variables" 4) At the User variables for User, click on Path. 5) Add the flutter sdk's path from (1). 6) Do the same for "System Variables". Double click on "Path" / click edit. 5) Add the flutter sdk's path from (1). 6) Restart visual studio code and then, all done! Solution found at:  https://stackoverflow.com/questions/70113055/vs-code-flutter-is-not-recognized-as-the-name-of-a-cmdlet
Post a Comment
Read more

MapBox Flutter Turn-by-turn Navigation - Not Updated / Not Working

 I have spent countless hours/days trying to fix the turn-by-turn navigation. I thought it was just me not understanding flutter and MapBox integration. Apparently, there was an issue in their SDK for turn-by-turn navigation. It has been fixed for Android native SDK but not for Flutter's. There may be a way to fix it. But I've decided to go native now. Bye Flutter. 😭 P.S. Share with me if you were able to make their turn-by-turn navigation a success!
Post a Comment
Read more