Recently I’ve made a decision to use mysql/mariadb command-line interface, because…
- I’ve not found any good, fast, free and opensource GUI client,
- I think, that CLI is more agile, stable and gets alot more support
So, I’ve started to use CLI and read manuals/google when I need something particular.
And here is some useful links:
- Create UTF8 table
- How To Create a New User and Grant Permissions in MySQL @ DigitalOcean community help
- ArchLinux Wiki MariaDB page
Also, while migrating to CLI, I’ve found some minor problem with long passwords. I’ve described it here:
- Question on DBA@StackExchange
- “Cannot login through CLI, but phpmyadmin works well” @ ArchLinux Wiki MariaDb page
I hope, my contribution will be helpful for other guys who pefer long passwords.