KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My requirement is to create a user for remote login but without a password. At my remote space I use a bash script to do inserts, which is something like: for i in {1..5000}; do mysql -h 11.40.3.169 -uUser -pPass -DDatabaseName <<< "insert into DatabaseTableName values('$i','dummy_$i');" & echo -n "$i " sleep 1 date done The problem is that each insert is taking almost 4 seconds, and I can not pinpoint the problem to anything but authentication at every insert. So, if I could create a user in MySQL with minimal authentication involved...Something like: # I'm trying to remove this password GRANT ALL PRIVILEGES TO 'user'@'%' IDENTIFIED BY 'password'; ...Anything you can suggest.
Tags (comma-separated)
Save Edits
Cancel