✅ new to MySql and trying to set up a basic database that will get connected to a .net projekt
ive set up my MySqlworkbench file and called it WordDatabase but cant seem to open a connection to the MySql server saying it cant connect
dunno how to make it actually connect would gladly appreciate some guidance
28 Replies
Can you replace your connection string with:
Server=localhost;Port=3306;Database=WordDatabase;Uid=root;Pwd=pass!; and try again?did you try opening that with tool like mysql workbench?
since you have a : instead of a ; in your connection string seperating the port and server
if i do that i just get this error instead
that user doesn't have permissions 🤔
are any others?
sry trying to figure out how to give privileges to root user GRANT all privileges ON object TO 'username'@'%' IDENTIFIED BY 'pass';
in MySql workbench
if you are using workbench you can do it from the gui itself
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
odd my both my instuctors advised me to use MySQL workbench after trying to use the build in SQL tools in visual studios which was a mess
so thats annoying
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
i will thank you
root now has access to everything he already had all admin roles and now all schema privileges same error message
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
using System;
using System.Data;
using System.Data.SQLite;
using MySql.Data.MySqlClient;
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
mySQL.Data by oracle, SQLite by SQlite dev team and System.Data.SQlite
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
idk
sure
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
If your code is too long, you can post to https://paste.mod.gg/, save, and copy the link into chat for others to see your shared code!
sry
https://paste.mod.gg/papenceebrbh/3 tell me if this works
BlazeBin - papenceebrbh
A tool for sharing your source code with the world!
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
this better?
Unknown User•2d ago
Message Not Public
Sign In & Join Server To View
not entirely sure what ur asking sry
if ur refering to my nuget packages
Unknown User•20h ago
Message Not Public
Sign In & Join Server To View