Score:0

Can't login with a unique username into mysql

gs flag

I am trying to connect a existing server files with my new machine. I need to be able to connect with a username "????", but for some reason mysql is not accepting that.

Using root as username it prompts me into entering password

As for using ???? as username it acts as if I asked to see help..

Can I make mysql accepting ???? as a username? If so - how?

Thanks in advance!

ua flag
What OS? Windows `cmd` needs `chcp 65001`. Linux might need the terminal to be set to UTF-8.
Gerald Young avatar
gs flag
Sorry for not including OS right away. I am using ubuntu 20.10. It seems that it is already en_US.UTF-8 UTF-8 by default. This is not the issue..
ua flag
What quoting do you use? Are you coming from a shell script or from some app?
dave_thompson_085 avatar
jp flag
Do you have more than one file with a four-character name in your current directory? If so in a Unix shell (but not some other systems) `mysql -u ????` expands to something like `mysql -u bear fork hair nerd taxi tree` which is course not a valid set of arguments for `mysql` and thus produces the 'help' message.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.