Tuesday, July 13, 2021
In this post we are going to circle back to MySQL and continue setting up our MySQL database, so that we can use it in our application. Since we don't want to use our root for log in and we turned off root login for remote connection. We have to create a dedicated user for our application. Here are the steps to create a dedicated dev use in MySQL
1. Log into MySQL with root using this command mysql -u root -p
2. In the MySQL prompt type CREATE User 'devuser'@'localhost' IDENTIFIED BY 'P@ssw0rd'; to create the user, obviously if this is your production environment you would want to use a more secure password
3. Then type GRANT ALL PRIVILEGES ON *.* TO 'devuser'@'localhost' WITH GRANT OPTION; to grant the user all the privileges on all the objects
4. Now type FLUSH PRIVILEGES; to update and apply the privileges
5. Now type quit, press Enter then try to log in with this command mysql -u devuser -p
Previous: Running Your Asp.Net Core Application For The First Time
Amazing Article, Really useful information to all So, I hope you will share more information to be check and share here.
ReplyDeleteJupyter Notebook
Jupyter Notebook Online
Jupyter Notebook Install
Automation Anywhere Tutorial
Rpa automation anywhere tutorial pdf
Automation anywhere Tutorial for beginners
Kivy Python
Kivy Tutorial
Kivy for Python
Kivy Installation on Windows
Thankyou for sharing this amazing post with us.
ReplyDeleteYour blog is very informative, finally, I found exactly what I want. Paypal is an excellent service for online payments but lots of its users confront issues while they access Paypal. If you want to resolve your problems then must visit contact Paypal Nederland.
ReplyDeleteYour blog is very informative and interesting to read, finally, I found exactly what I search for. There are lots of users of Macfee antivirus in the world because of its features and easy interface. If you want to explore more interesting facts about Mcafee antivirus or want to resolve your technical issues then must visit Mcafee ondersteuning nummer.
ReplyDeleteNice Blog, We are professional website designing company in delhi to provide creative and responsive website design.
ReplyDeleteLove back Solution Specialist
Vashikaran specialist
Love Vashikaran Specialist
Vashikaran Specialist in India Vashikaran Specialist in Bangalore Vashikaran Specialist in Mumbai Love Vashikaran Specialist in MumbaiBlack magic specialist astrologer
I really appreciate the information that you have shared on your Blog. Thanks for shearing this blog.
ReplyDeleteHow to Unpause Printer
How to Unpause Printer
How Do I Get My HP Envy 4500 Printer Back Online
How Do You Change a Printer from Offline to Online?
How to Reset HP Printer to Factory Settings
HP Printer Drivers For Windows 7
Computer Recognizes Printer But Not Scanner
How Do I Update My HP Printer Firmware
I am Intrested to the site and thanks for this site ...keep sharing
ReplyDeleteBest Technology details read content
coffee distributor 53mm
ReplyDeletetchibo coffee capsule
coffee temper distributor
eva zipper bag
chinese 125cc motorcycles
60km Electric Moped wholesale
Electric Moped Scooter EEC
practical spout pouch for juice
sustainable packaging with spouted and liquid pouches
wholesale glitter
china reusable liquid food spout pouch supplier
Laminated Glass railing clamp
glass door patch fitting set for sale
glass door patch fitting factory
Nigeria Abaya dress cloth
50 liter waterproof backpack
Round Clip On Sunglasses odm
wholesale cute loaf pan
china bathroom furniture design factory
wholesale porcelain floor tiles 600x600
Baby ornaments personalized manufacturer
delivery bag manufacture
trunk bag manufacture
wholesale glitter
salmosan azamethiphos
opgw
bulk glitter
acetate spectacle frames with printing
Polarized Clip On Sunglasses odm
oversize acetate sunglasses with custom
coffee tamper espresso distributor
Simple Kitchen Cabinet for sale