tidb安装好之后本地不能登陆客户端可以

不会读取吧,我只是下载了一个mysqltar包,解压之后用他的mysql命令。没有安装mysql

mysql client 前面加一下 trace 看下输出吧,你现在还有别的思路么

trace是什么命令?单独下载?
image

yum install trace -y
strace mysql -uroot -p123456 -h xxxxx

是不是这个??、

全部内容:
[tidb@tidb1 ~]$ strace mysql -uroot -p123456 -h192.168.81.131 -P 4000
execve(“/usr/local/mysql/bin/mysql”, [“mysql”, “-uroot”, “-p123456”, “-h192.168.81.131”, “-P”, “4000”], 0x7ffe49f6d6a8 /* 19 vars /) = 0
brk(NULL) = 0x1ef5000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88cb000
readlink(“/proc/self/exe”, “/usr/local/mysql/bin/mysql”, 4096) = 26
access(“/etc/ld.so.preload”, R_OK) = -1 ENOENT (No such file or directory)
open(“/usr/local/mysql/bin/…/lib/private/tls/x86_64/libpthread.so.0”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(“/usr/local/mysql/bin/…/lib/private/tls/x86_64”, 0x7ffd849c9890) = -1 ENOENT (No such file or directory)
open(“/usr/local/mysql/bin/…/lib/private/tls/libpthread.so.0”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(“/usr/local/mysql/bin/…/lib/private/tls”, 0x7ffd849c9890) = -1 ENOENT (No such file or directory)
open(“/usr/local/mysql/bin/…/lib/private/x86_64/libpthread.so.0”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(“/usr/local/mysql/bin/…/lib/private/x86_64”, 0x7ffd849c9890) = -1 ENOENT (No such file or directory)
open(“/usr/local/mysql/bin/…/lib/private/libpthread.so.0”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(“/usr/local/mysql/bin/…/lib/private”, {st_mode=S_IFDIR|0755, st_size=151, …}) = 0
open(“/etc/ld.so.cache”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=37680, …}) = 0
mmap(NULL, 37680, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f16e88c1000
close(3) = 0
open(“/lib64/libpthread.so.0”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200m\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=142144, …}) = 0
mmap(NULL, 2208904, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e848f000
mprotect(0x7f16e84a6000, 2093056, PROT_NONE) = 0
mmap(0x7f16e86a5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7f16e86a5000
mmap(0x7f16e86a7000, 13448, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e86a7000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/librt.so.1”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/librt.so.1”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000"\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=43712, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88c0000
mmap(NULL, 2128952, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e8287000
mprotect(0x7f16e828e000, 2093056, PROT_NONE) = 0
mmap(0x7f16e848d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x7f16e848d000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libcrypto.so.1.1”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\220\7\0\0\0\0\0”…, 832) = 832
lseek(3, 3080192, SEEK_SET) = 3080192
read(3, “\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”…, 392) = 392
fstat(3, {st_mode=S_IFREG|0755, st_size=3169416, …}) = 0
lseek(3, 3080192, SEEK_SET) = 3080192
read(3, “\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”…, 392) = 392
mmap(NULL, 4922504, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e7dd5000
mprotect(0x7f16e8040000, 2297856, PROT_NONE) = 0
mmap(0x7f16e823f000, 188416, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x26a000) = 0x7f16e823f000
mmap(0x7f16e826d000, 14656, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e826d000
mmap(0x7f16e8271000, 90112, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2f0000) = 0x7f16e8271000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libssl.so.1.1”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300\332\1\0\0\0\0\0”…, 832) = 832
lseek(3, 663552, SEEK_SET) = 663552
read(3, “\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”…, 392) = 392
fstat(3, {st_mode=S_IFREG|0755, st_size=683784, …}) = 0
lseek(3, 663552, SEEK_SET) = 663552
read(3, “\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”…, 392) = 392
mmap(NULL, 2686728, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e7b45000
mprotect(0x7f16e7bc4000, 2146304, PROT_NONE) = 0
mmap(0x7f16e7dc3000, 53248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7e000) = 0x7f16e7dc3000
mmap(0x7f16e7dd0000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa2000) = 0x7f16e7dd0000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libdl.so.2”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libdl.so.2”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P\16\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=19248, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88bf000
mmap(NULL, 2109744, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e7941000
mprotect(0x7f16e7943000, 2097152, PROT_NONE) = 0
mmap(0x7f16e7b43000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7f16e7b43000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libresolv.so.2”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libresolv.so.2”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\2009\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=109976, …}) = 0
mmap(NULL, 2202112, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e7727000
mprotect(0x7f16e773d000, 2097152, PROT_NONE) = 0
mmap(0x7f16e793d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7f16e793d000
mmap(0x7f16e793f000, 6656, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e793f000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libtinfo.so.5”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libtinfo.so.5”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0@\316\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=174576, …}) = 0
mmap(NULL, 2268928, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e74fd000
mprotect(0x7f16e7522000, 2097152, PROT_NONE) = 0
mmap(0x7f16e7722000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x25000) = 0x7f16e7722000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libstdc++.so.6”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libstdc++.so.6”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\264\5\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=995840, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88be000
mmap(NULL, 3175456, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e71f5000
mprotect(0x7f16e72de000, 2097152, PROT_NONE) = 0
mmap(0x7f16e74de000, 40960, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe9000) = 0x7f16e74de000
mmap(0x7f16e74e8000, 82976, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e74e8000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libm.so.6”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libm.so.6”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0PS\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1136944, …}) = 0
mmap(NULL, 3150136, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e6ef3000
mprotect(0x7f16e6ff4000, 2093056, PROT_NONE) = 0
mmap(0x7f16e71f3000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x100000) = 0x7f16e71f3000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libgcc_s.so.1”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libgcc_s.so.1”, O_RDONLY|O_CLOEXEC) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320
\0\0\0\0\0\0"…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=88720, …}) = 0
mmap(NULL, 2184192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e6cdd000
mprotect(0x7f16e6cf2000, 2093056, PROT_NONE) = 0
mmap(0x7f16e6ef1000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x7f16e6ef1000
close(3) = 0
open(“/usr/local/mysql/bin/…/lib/private/libc.so.6”, O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open(“/lib64/libc.so.6”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`&\2\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=2156272, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88bd000
mmap(NULL, 3985920, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e690f000
mprotect(0x7f16e6ad3000, 2093056, PROT_NONE) = 0
mmap(0x7f16e6cd2000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1c3000) = 0x7f16e6cd2000
mmap(0x7f16e6cd8000, 16896, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e6cd8000
close(3) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88bc000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88bb000
mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88b9000
arch_prctl(ARCH_SET_FS, 0x7f16e88b9780) = 0
mprotect(0x7f16e6cd2000, 16384, PROT_READ) = 0
mprotect(0x7f16e6ef1000, 4096, PROT_READ) = 0
mprotect(0x7f16e71f3000, 4096, PROT_READ) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88b8000
mprotect(0x7f16e74de000, 32768, PROT_READ) = 0
mprotect(0x7f16e7722000, 16384, PROT_READ) = 0
mprotect(0x7f16e793d000, 4096, PROT_READ) = 0
mprotect(0x7f16e7b43000, 4096, PROT_READ) = 0
mprotect(0x7f16e86a5000, 4096, PROT_READ) = 0
mprotect(0x7f16e848d000, 4096, PROT_READ) = 0
mprotect(0x7f4000, 20480, PROT_READ) = 0
mprotect(0x7f16e88cc000, 4096, PROT_READ) = 0
munmap(0x7f16e88c1000, 37680) = 0
set_tid_address(0x7f16e88b9a50) = 6436
set_robust_list(0x7f16e88b9a60, 24) = 0
rt_sigaction(SIGRTMIN, {sa_handler=0x7f16e8495860, sa_mask=[], sa_flags=SA_RESTORER|SA_SIGINFO, sa_restorer=0x7f16e849e630}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {sa_handler=0x7f16e84958f0, sa_mask=[], sa_flags=SA_RESTORER|SA_RESTART|SA_SIGINFO, sa_restorer=0x7f16e849e630}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=327681024, rlim_max=327681024}) = 0
brk(NULL) = 0x1ef5000
brk(0x1f16000) = 0x1f16000
brk(NULL) = 0x1f16000
futex(0x7f16e74fa96c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e74fa978, FUTEX_WAKE_PRIVATE, 2147483647) = 0
ioctl(0, TCGETS, {B38400 opost isig icanon echo …}) = 0
ioctl(1, TCGETS, {B38400 opost isig icanon echo …}) = 0
dup(1) = 3
close(3) = 0
stat(“/etc/my.cnf”, {st_mode=S_IFREG|0644, st_size=629, …}) = 0
open(“/etc/my.cnf”, O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=629, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
read(3, “[mysqld]\ndatadir=/data/mysql\nsoc”…, 4096) = 629
openat(AT_FDCWD, “/etc/my.cnf.d/”, O_RDONLY|O_NONBLOCK|O_CLOEXEC|O_DIRECTORY) = 4
getdents(4, /* 3 entries /, 32768) = 88
getdents(4, /
0 entries */, 32768) = 0
close(4) = 0
stat(“/etc/my.cnf.d/mysql-clients.cnf”, {st_mode=S_IFREG|0644, st_size=232, …}) = 0
open(“/etc/my.cnf.d/mysql-clients.cnf”, O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=232, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88c9000
read(4, “#\n# These groups are read by Mar”…, 4096) = 232
read(4, “”, 4096) = 0
close(4) = 0
munmap(0x7f16e88c9000, 4096) = 0
read(3, “”, 4096) = 0
close(3) = 0
munmap(0x7f16e88ca000, 4096) = 0
stat(“/etc/mysql/my.cnf”, 0x7ffd849c6170) = -1 ENOENT (No such file or directory)
stat(“/usr/local/mysql/etc/my.cnf”, 0x7ffd849c6170) = -1 ENOENT (No such file or directory)
stat(“/home/tidb/.my.cnf”, 0x7ffd849c6170) = -1 ENOENT (No such file or directory)
stat(“/home/tidb/.mylogin.cnf”, 0x7ffd849c6170) = -1 ENOENT (No such file or directory)
geteuid() = 1002
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_UNIX, sun_path=“/var/run/nscd/socket”}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_UNIX, sun_path=“/var/run/nscd/socket”}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
open(“/etc/nsswitch.conf”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=1949, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
read(3, “#\n# /etc/nsswitch.conf\n#\n# An ex”…, 4096) = 1949
read(3, “”, 4096) = 0
close(3) = 0
munmap(0x7f16e88ca000, 4096) = 0
open(“/etc/ld.so.cache”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=37680, …}) = 0
mmap(NULL, 37680, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f16e88c1000
close(3) = 0
open(“/lib64/libnss_files.so.2”, O_RDONLY|O_CLOEXEC) = 3
read(3, “\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260!\0\0\0\0\0\0”…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=61560, …}) = 0
mmap(NULL, 2173048, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f16e66fc000
mprotect(0x7f16e6708000, 2093056, PROT_NONE) = 0
mmap(0x7f16e6907000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xb000) = 0x7f16e6907000
mmap(0x7f16e6909000, 22648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f16e6909000
close(3) = 0
mprotect(0x7f16e6907000, 4096, PROT_READ) = 0
munmap(0x7f16e88c1000, 37680) = 0
open(“/etc/passwd”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=1405, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
read(3, “root:x:0:0:root:/root:/bin/bash\n”…, 4096) = 1405
close(3) = 0
munmap(0x7f16e88ca000, 4096) = 0
write(2, “mysql: “, 7mysql: ) = 7
write(2, “[Warning] Using a password on th”…, 73[Warning] Using a password on the command line interface can be insecure.) = 73
write(2, “\n”, 1
) = 1
ioctl(0, TCGETS, {B38400 opost isig icanon echo …}) = 0
ioctl(1, TCGETS, {B38400 opost isig icanon echo …}) = 0
futex(0x7f16e826f10c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f114, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f11c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f268, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f12c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f134, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826c5c0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f028, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826c690, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826c680, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f124, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f168, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e826f170, FUTEX_WAKE_PRIVATE, 2147483647) = 0
getuid() = 1002
geteuid() = 1002
getgid() = 1003
getegid() = 1003
open(”/usr/local/mysql/ssl/openssl.cnf”, O_RDONLY) = -1 ENOENT (No such file or directory)
futex(0x7f16e826f13c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7f16e7dcf5e8, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open(“/proc/meminfo”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0444, st_size=0, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
read(3, “MemTotal: 2366840 kB\nMemF”…, 1024) = 1024
close(3) = 0
munmap(0x7f16e88ca000, 4096) = 0
futex(0x7f16e7dcf730, FUTEX_WAKE_PRIVATE, 2147483647) = 0
brk(NULL) = 0x1f16000
brk(0x1f37000) = 0x1f37000
futex(0x7f16e7dcf738, FUTEX_WAKE_PRIVATE, 2147483647) = 0
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_UNIX, sun_path=“/var/run/nscd/socket”}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
connect(3, {sa_family=AF_UNIX, sun_path=“/var/run/nscd/socket”}, 110) = -1 ENOENT (No such file or directory)
close(3) = 0
open(“/etc/services”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=670293, …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
read(3, “# /etc/services:\n# $Id: services”…, 4096) = 4096
read(3, " 74/udp “…, 4096) = 4096
read(3, " # Quick Mail Transfer Proto”…, 4096) = 4096
read(3, " 636/udp “…, 4096) = 4096
read(3, " # Microsoft-SQL-Monito”…, 4096) = 4096
read(3, " # discp s"…, 4096) = 4096
close(3) = 0
munmap(0x7f16e88ca000, 4096) = 0
rt_sigaction(SIGPIPE, {sa_handler=SIG_IGN, sa_mask=[PIPE], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f16e6945400}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
open(“/usr/lib/locale/locale-archive”, O_RDONLY|O_CLOEXEC) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=106172832, …}) = 0
mmap(NULL, 106172832, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f16e01ba000
close(3) = 0
stat(“/usr/local/mysql/share/charsets/Index.xml”, {st_mode=S_IFREG|0644, st_size=19495, …}) = 0
open(“/usr/local/mysql/share/charsets/Index.xml”, O_RDONLY) = 3
read(3, “<?xml version=‘1.0’ encoding="ut”…, 19495) = 19495
close(3) = 0
futex(0xaf55d0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
socket(AF_INET, SOCK_STREAM, IPPROTO_TCP) = 3
connect(3, {sa_family=AF_INET, sin_port=htons(4000), sin_addr=inet_addr(“192.168.81.131”)}, 16) = 0
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
recvfrom(3, “V\0\0\0\n5.7.25-TiDB-v4.0.2\0\330\0\0\0003’sl”…, 16384, 0, NULL, NULL) = 90
sendto(3, “\257\0\0\1\205\246\377\t\0\0\0\1\377\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0”…, 179, 0, NULL, 0) = 179
recvfrom(3, “L\0\0\2\377\25\4#28000Access denied for u”…, 16384, 0, NULL, NULL) = 80
shutdown(3, SHUT_RDWR) = 0
close(3) = 0
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 3), …}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f16e88ca000
write(2, "ERROR 1045 (28000): ", 20ERROR 1045 (28000): ) = 20
write(2, “Access denied for user ‘root’@'1”…, 67Access denied for user ‘root’@‘192.168.81.131’ (using password: NO)) = 67
write(2, “\n”, 1
) = 1
write(1, “\7”, 1) = 1
rt_sigaction(SIGQUIT, {sa_handler=SIG_IGN, sa_mask=[QUIT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f16e6945400}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGINT, {sa_handler=SIG_IGN, sa_mask=[INT], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f16e6945400}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
rt_sigaction(SIGHUP, {sa_handler=SIG_IGN, sa_mask=[HUP], sa_flags=SA_RESTORER|SA_RESTART, sa_restorer=0x7f16e6945400}, {sa_handler=SIG_DFL, sa_mask=[], sa_flags=0}, 8) = 0
exit_group(1) = ?
+++ exited with 1 +++


好多 No such file or directory 这个玩意

这有什么关系么?这个不是mysql的吗?我只是用mysqltar包解压之后的bin/mysql命令 my.cnf只有在etc下面是有的。。其他路径怎么可能会有这个文件呢
my.cnf文件也没有什么内容
image

我找了一个正常的 这三个路径下也没有my.cnf文件。正常情况下除了etc目录下其他地方不可能有my.cnf文件的

我就是打眼一看这个比较多 :laughing:

还没解决呢?不行就提BUG吧,哈哈

换一个客户端试试,mycli
https://github.com/dbcli/mycli

算了 ,不管了。搞了四五套测试环境就这一个有问题,怀疑是这个服务器之前安装其他环境影响的。不是新建的服务器。

里面是不是有mariaDB,要不卸载空,看看

从你的报错应该是密码没有输入进去,可以先通过navicat客户端看下系统表中的user表有没有设置固定的ip才可以访问

登录进去,重新建立一个用户,设置好密码,已经登录ip后在登录试试呢。

感觉密码没有输入进去

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。