R
Railway•15mo ago
Nathan Lively

How to use a new MySQL user for database connections?

I have created a new database in MySQL using Workbench and a new user for that database using the Railway CLI. After deployment, I'm getting an Access denied error. Why can't this user connect?
4 Replies
Percy
Percy•15mo ago
Project ID: 525a439a-8964-45cd-b169-b621d0c1fe25
Nathan Lively
Nathan Lively•15mo ago
525a439a-8964-45cd-b169-b621d0c1fe25
Brody
Brody•15mo ago
I've seen a lot of issues when users don't use the default railway database along with the provided credentials, the databases on railway aren't the best they could be, so please stick with the railway named database and just the provided credentials for the best experience
Nathan Lively
Nathan Lively•15mo ago
hmmm, ok. So it's not recommended to create users and grant them specific privileges like you would do on another virtual machine? I'm not sure how to dump all of my tables without the schema. I'll look into that. As far as I can tell, there's no way to just copy tables from one schema to another.
Want results from more Discord servers?
Add your server
More Posts
How to create a remoteuser for MySQL Workbench connection?Hi. I used the Railway CLI to create a new remoteuser in MySQL. Then, I attempted to connect to the Application failed to respondMy nx app get that error: ```bash yarn run v1.22.19 $ nx serve app --prod --port 5564 > nx run app:Error on SELECT Queries MySQLSo I have my API in JS deployed with an MySQL DB, I can run any Query but SELECTS, even with ThunderUnable to upload codeHi there, I'm trying to upload my project to railway as for hosting it... Using railway's CLI, I'veGithub Not WorkingI can't find any of my github projectsInternal server error when I try to login with GitHubI don’t have my project ids. Happy to DM my Github info.Docker ran out of memory? Developer planBuild are crashing with this message from docker: >>>7H35BIQK: no space left on device How do youBooting worker looping infinitelyHi there, I'm facing an issue where "Booting worker with pid: XXX" is looping infinitely despite no No space on device error - no change since last deployHi there -- Just redeployed my app with no major changes (new packages, etc). I'm getting a "no spacreact deployment failed due to unknown reasonThe build succeeds but then the deployement of my applications fails. The only thing that I could co