This is down to your database setup (not a node-red or node issue).
The default configuration of mysql allows connections only from the 'root' user when coming from 'localhost' and not other IP addresses. There are many answers on the web.
Yes i did click the link.
Read the solution.
Applied some.
Works and shows connection successful.
And then after ingesting from NodeRED into Mysql node....NODERED CRASHES.
Have you looked at the existing issues on the GitHub repository - it might already be raised as an issue. If not, raise an issue and describe what you are doing and show the stack trace from the console.