In Debian **Desktop** 12 if I want to do a remote connection as client to a MySQL Server in other machine in the LAN I need use the mysql command, when it is executed happens the following:

manueljordan@vm163:~$ mysql 
bash: mysql: command not found

If is executed the apt search mysql-client command happens the following:

manueljordan@vm163:~$ apt search mysql-client
Sorting... Done
Full Text Search... Done
default-mysql-client/stable 1.1.0 all
  MySQL database client binaries (metapackage)

default-mysql-client-core/stable 1.1.0 all
  MySQL database core client binaries (metapackage)

Therefore: * What is the correct package to install? **default-mysql-client** or **default-mysql-client-core**? and Why? And just being curious: * What exists two packages? * What is the difference between them? Thanks in advance

As the question title suggests: I have set max_connections = 2 in my my.cnf file, but when I activate my mysql daemon, the thread count sits at 37. I am searching online but cannot find indication my expectations are wrong. Am I understanding the max_connections directive correctly ? Can anyone suggest a reason as to why this may not be limiting the thread count ? Attempts at a solution --------------------- 1) I query mysql global variables via the mysql CLI client:

| Variable_name              | Value                |
+----------------------------+----------------------+
| max_allowed_packet         | 67108864             |
| max_binlog_cache_size      | 18446744073709547520 |
| max_binlog_size            | 1073741824           |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| max_connect_errors         | 100                  |
| max_connections            | 2                    |
| max_delayed_threads        | 20                   |
| max_digest_length          | 1024                 |
| max_error_count            | 1024                 |
| max_execution_time         | 0                    |
| max_heap_table_size        | 16777216             |
| max_insert_delayed_threads | 20                   |
| max_join_size              | 18446744073709551615 |
| max_length_for_sort_data   | 4096                 |
| max_points_in_geometry     | 65536                |
| max_prepared_stmt_count    | 16382                |
| max_relay_log_size         | 0                    |
| max_seeks_for_key          | 18446744073709551615 |
| max_sort_length            | 1024                 |
| max_sp_recursion_depth     | 0                    |
| max_user_connections       | 2                    |
| max_write_lock_count       | 18446744073709551615 |

This confirms the my.cnf file is being correctly loaded as the max_connections variable is indeed set to 2. 2) As is visible from the output in (1), I have attempted limiting the max_user_connections variable also, but again, no luck. 3) I killed other server processes that I suspected could be querying the mysql daemon - httpd, php-fpm, but this has not reduced the number of threads. System Specs ------------ My MySQL version is 8.3.0, and is a minimal install:

mysql-8.3.0-linux-glibc2.17-x86_64-minimal

Update ------ Running the query SHOW PROCESSLIST returns:

*************************** 1. row ***************************
     Id: 5
   User: event_scheduler
   Host: localhost
     db: NULL
Command: Daemon
   Time: 146457
  State: Waiting on empty queue
   Info: NULL
*************************** 2. row ***************************
     Id: 11
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: init
   Info: SHOW PROCESSLIST
2 rows in set, 1 warning (0.00 sec)

I found more helpful running SELECT * FROM performance_schema_threads\G, which returned information about many tasks mysqld is executing. I had a suspicion this list of tasks would correspond to the number of threads and running:

SELECT COUNT(*) FROM performance_schema.threads\G

Returns:

38

Which nicely corresponds to the number of threads - I suspect the extra task corresponds to the master process. In the terminal:

pstree | grep sql
|-mysqld---37*[{mysqld}

Reading through the task names returned by performance_schema.threads, I gather these threads are necessary for MySQL to function as their names are io_read_thread,io_write_thread,log_writer_thread and similar. Setting max_connections works as expected - setting max_user_connections=2 and attempting to open a third client as root returns:

ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections

However, if max_connections is set to 2, while max_user_connections is at 6, I can have 3 mysql clients open at once with user root. When I try and open a fourth client as root, I receive:

ERROR 1040 (HY000): Too many connections

How does a limit of three client sessions under one user arise from my.cnf limits of:

max_connections = 2
max_user_connections = 6
thread_cache_size = 2

? I am continuing to read up MySQL documentation but am yet to find an explanation. If someone more experienced can offer clarity, I would be greatly appreciative. How do these settings affect connection (and so thread) number ?

Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ? It must monitor below parameters. 1. mysql more than 500 concurrent connections. 2. mysql deadlocks. 3. connection between mysql and application. And some more like this.

I upgraded my VPS with the provider Contabo, and since then, I have been experiencing issues. Unfortunately, they have not been responsive or provided any support. when i do command : service mysql start, it return The full MySQL error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ? Command : sudo systemctl status mysql , gives: mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2023-10-30 03:51:56 CET; 9s ago Process: 4936 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE) Oct 30 03:51:56 vmi891613.contaboserver.net systemd: mysql.service: Scheduled restart job, restart counter is at 5. Oct 30 03:51:56 vmi891613.contaboserver.net systemd: Stopped MySQL Community Server. Oct 30 03:51:56 vmi891613.contaboserver.net systemd: mysql.service: Start request repeated too quickly. Oct 30 03:51:56 vmi891613.contaboserver.net systemd: mysql.service: Failed with result 'exit-code'. Oct 30 03:51:56 vmi891613.contaboserver.net systemd: Failed to start MySQL Community Server. I tried restart "*sudo systemctl start mysql* ", but shows: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. the systemctl status mysql.service gives the same mentioned before. if any one know how to fix this without losing my websites in the VPS, please help i have like 6 domians in this VPN and the service provider (Contabo) not helping. its been 48 hours and the financial losses continue to mount with each passing hour.

I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused about where I might be making a mistake. I changed the password for root on localhost, but it's not working in one specific condition. The server starts working only when I use the following commands: systemctl stop mysql mkdir /var/run/mysqld chown mysql /var/run/mysqld mysqld_safe --skip-grant-tables & After that, I just type mysql -u root and hit Enter, and the server starts working. However, when I close Putty, it stops working, and I encounter the error "1045 (28000)" again.

I have a program which uses msqllib. It scans some hardware that I build and then updates a mysql database. This program has been running for a number of years but I have never been able to autostart it when the system reboots. Now I have an issue with power cycling that is beyond my control, so want to get it running automaticaly. In rc.local : I have: #!/bin/sh -e # # rc.local # # This script is executed at the end of each multiuser runlevel. # Make sure that the script will "exit 0" on success or any other # value on error. # # In order to enable or disable this script just change the execution # bits. # # By default this script does nothing. # Print the IP address _IP=$(hostname -I) || true if [ "$_IP" ]; then printf "My IP address is %s\n" "$_IP" fi /home/nigel/scan exit 0 Now, the code runs fine when I enter it at a command prompt, and updates my database. However, when I put it in rc.local, ps -ef shows: root 356 350 0 20:54 ? 00:00:03 /home/nigel/scan but the program is not executing the SQL calls to update the database. If I ask for the statius of rc.local: root@Pi-Scan:~# systemctl status rc-local.service ● rc-local.service - /etc/rc.local Compatibility Loaded: loaded (/lib/systemd/system/rc-local.service; enabled-runtime; vendor preset: enabled) Drop-In: /usr/lib/systemd/system/rc-local.service.d └─debian.conf /etc/systemd/system/rc-local.service.d └─ttyoutput.conf Active: activating (start) since Sat 2023-05-06 20:54:19 EDT; 12min ago Docs: man:systemd-rc-local-generator(8) Cntrl PID: 350 (rc.local) Tasks: 2 (limit: 414) CPU: 3.903s CGroup: /system.slice/rc-local.service ├─350 /bin/sh -e /etc/rc.local start └─356 /home/nigel/scan May 06 20:54:21 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:22 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:23 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:24 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:25 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:26 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:27 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected May 06 20:54:28 Pi-Scan rc.local: error: first parameter is not a valid address family: Transport endpoint is not connected However if I issue systemctl restart rc-local.service The program executes a second instance and works fine! Thinking that this may be a racing condition, I have tried adding a sleep 5 before the command and still get the same problems.

I am trying to install MySQL on Ubuntu 22.04 (WSL2) and these are the steps that I did: 1- Installing mysql server:

root@mans-pc:~# sudo apt-get update
Get:1 http://security.ubuntu.com/ubuntu  jammy-security InRelease [110 kB]
Hit:2 http://archive.ubuntu.com/ubuntu  jammy InRelease
Get:3 http://archive.ubuntu.com/ubuntu  jammy-updates InRelease [119 kB]
Get:4 http://security.ubuntu.com/ubuntu  jammy-security/universe amd64 c-n-f Metadata [13.4 kB]
Get:5 http://archive.ubuntu.com/ubuntu  jammy-backports InRelease [107 kB]
Get:6 http://archive.ubuntu.com/ubuntu  jammy-updates/universe amd64 Packages [870 kB]
Get:7 http://archive.ubuntu.com/ubuntu  jammy-updates/universe Translation-en [169 kB]
Get:8 http://archive.ubuntu.com/ubuntu  jammy-updates/universe amd64 c-n-f Metadata [17.5 kB]
Fetched 1,406 kB in 2s (671 kB/s)
Reading package lists... Done
root@mans-pc:~# sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7 libfcgi-bin libfcgi-perl
  libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl
  libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite23 libtimedate-perl liburi-perl mecab-ipadic
  mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0 mysql-server-core-8.0
Suggested packages:
  libdata-dump-perl libipc-sharedcache-perl libbusiness-isbn-perl libwww-perl mailx tinyca
The following NEW packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libclone-perl libencode-locale-perl libevent-pthreads-2.1-7 libfcgi-bin libfcgi-perl
  libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl
  libio-html-perl liblwp-mediatypes-perl libmecab2 libprotobuf-lite23 libtimedate-perl liburi-perl mecab-ipadic
  mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server mysql-server-8.0
  mysql-server-core-8.0
0 upgraded, 28 newly installed, 0 to remove and 0 not upgraded.
Need to get 29.5 MB of archives.
After this operation, 242 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://archive.ubuntu.com/ubuntu  jammy/main amd64 mysql-common all 5.8+1.0.8 [7,212 B]
Get:2 http://archive.ubuntu.com/ubuntu  jammy-updates/main amd64 mysql-client-core-8.0 amd64 8.0.32-0ubuntu0.22.04.2 [2,677 kB]
Get:3 http://archive.ubuntu.com/ubuntu  jammy-updates/main amd64 mysql-client-8.0 amd64 8.0.32-0ubuntu0.22.04.2 [22.7 kB]
Get:4 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libevent-pthreads-2.1-7 amd64 2.1.12-stable-1build3 [7,642 B]
Get:5 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libmecab2 amd64 0.996-14build9 [199 kB]
Get:6 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libprotobuf-lite23 amd64 3.12.4-1ubuntu7 [208 kB]
Get:7 http://archive.ubuntu.com/ubuntu  jammy-updates/main amd64 mysql-server-core-8.0 amd64 8.0.32-0ubuntu0.22.04.2 [17.5 MB]
Get:8 http://archive.ubuntu.com/ubuntu  jammy-updates/main amd64 mysql-server-8.0 amd64 8.0.32-0ubuntu0.22.04.2 [1,427 kB]
Get:9 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libhtml-tagset-perl all 3.20-4 [12.5 kB]
Get:10 http://archive.ubuntu.com/ubuntu  jammy/main amd64 liburi-perl all 5.10-1 [78.8 kB]
Get:11 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libhtml-parser-perl amd64 3.76-1build2 [88.4 kB]
Get:12 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libcgi-pm-perl all 4.54-1 [188 kB]
Get:13 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libfcgi0ldbl amd64 2.4.2-2build2 [28.0 kB]
Get:14 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libfcgi-perl amd64 0.82+ds-1build1 [22.8 kB]
Get:15 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libcgi-fast-perl all 1:2.15-1 [10.5 kB]
Get:16 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libclone-perl amd64 0.45-1build3 [11.0 kB]
Get:17 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libencode-locale-perl all 1.05-1.1 [11.8 kB]
Get:18 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libfcgi-bin amd64 2.4.2-2build2 [11.2 kB]
Get:19 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libhtml-template-perl all 2.97-1.1 [59.1 kB]
Get:20 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libtimedate-perl all 2.3300-2 [34.0 kB]
Get:21 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libhttp-date-perl all 6.05-1 [9,920 B]
Get:22 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libio-html-perl all 1.004-2 [15.4 kB]
Get:23 http://archive.ubuntu.com/ubuntu  jammy/main amd64 liblwp-mediatypes-perl all 6.04-1 [19.5 kB]
Get:24 http://archive.ubuntu.com/ubuntu  jammy/main amd64 libhttp-message-perl all 6.36-1 [76.8 kB]
Get:25 http://archive.ubuntu.com/ubuntu  jammy/main amd64 mecab-utils amd64 0.996-14build9 [4,850 B]
Get:26 http://archive.ubuntu.com/ubuntu  jammy/main amd64 mecab-ipadic all 2.7.0-20070801+main-3 [6,718 kB]
Get:27 http://archive.ubuntu.com/ubuntu  jammy/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-3 [4,384 B]
Get:28 http://archive.ubuntu.com/ubuntu  jammy-updates/main amd64 mysql-server all 8.0.32-0ubuntu0.22.04.2 [9,458 B]
Fetched 29.5 MB in 6s (4,860 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 58973 files and directories currently installed.)
Preparing to unpack .../0-mysql-common_5.8+1.0.8_all.deb ...
Unpacking mysql-common (5.8+1.0.8) ...
Selecting previously unselected package mysql-client-core-8.0.
Preparing to unpack .../1-mysql-client-core-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../2-mysql-client-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Selecting previously unselected package libevent-pthreads-2.1-7:amd64.
Preparing to unpack .../3-libevent-pthreads-2.1-7_2.1.12-stable-1build3_amd64.deb ...
Unpacking libevent-pthreads-2.1-7:amd64 (2.1.12-stable-1build3) ...
Selecting previously unselected package libmecab2:amd64.
Preparing to unpack .../4-libmecab2_0.996-14build9_amd64.deb ...
Unpacking libmecab2:amd64 (0.996-14build9) ...
Selecting previously unselected package libprotobuf-lite23:amd64.
Preparing to unpack .../5-libprotobuf-lite23_3.12.4-1ubuntu7_amd64.deb ...
Unpacking libprotobuf-lite23:amd64 (3.12.4-1ubuntu7) ...
Selecting previously unselected package mysql-server-core-8.0.
Preparing to unpack .../6-mysql-server-core-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up mysql-common (5.8+1.0.8) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 59187 files and directories currently installed.)
Preparing to unpack .../00-mysql-server-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Selecting previously unselected package libhtml-tagset-perl.
Preparing to unpack .../01-libhtml-tagset-perl_3.20-4_all.deb ...
Unpacking libhtml-tagset-perl (3.20-4) ...
Selecting previously unselected package liburi-perl.
Preparing to unpack .../02-liburi-perl_5.10-1_all.deb ...
Unpacking liburi-perl (5.10-1) ...
Selecting previously unselected package libhtml-parser-perl:amd64.
Preparing to unpack .../03-libhtml-parser-perl_3.76-1build2_amd64.deb ...
Unpacking libhtml-parser-perl:amd64 (3.76-1build2) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../04-libcgi-pm-perl_4.54-1_all.deb ...
Unpacking libcgi-pm-perl (4.54-1) ...
Selecting previously unselected package libfcgi0ldbl:amd64.
Preparing to unpack .../05-libfcgi0ldbl_2.4.2-2build2_amd64.deb ...
Unpacking libfcgi0ldbl:amd64 (2.4.2-2build2) ...
Selecting previously unselected package libfcgi-perl:amd64.
Preparing to unpack .../06-libfcgi-perl_0.82+ds-1build1_amd64.deb ...
Unpacking libfcgi-perl:amd64 (0.82+ds-1build1) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../07-libcgi-fast-perl_1%3a2.15-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.15-1) ...
Selecting previously unselected package libclone-perl.
Preparing to unpack .../08-libclone-perl_0.45-1build3_amd64.deb ...
Unpacking libclone-perl (0.45-1build3) ...
Selecting previously unselected package libencode-locale-perl.
Preparing to unpack .../09-libencode-locale-perl_1.05-1.1_all.deb ...
Unpacking libencode-locale-perl (1.05-1.1) ...
Selecting previously unselected package libfcgi-bin.
Preparing to unpack .../10-libfcgi-bin_2.4.2-2build2_amd64.deb ...
Unpacking libfcgi-bin (2.4.2-2build2) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../11-libhtml-template-perl_2.97-1.1_all.deb ...
Unpacking libhtml-template-perl (2.97-1.1) ...
Selecting previously unselected package libtimedate-perl.
Preparing to unpack .../12-libtimedate-perl_2.3300-2_all.deb ...
Unpacking libtimedate-perl (2.3300-2) ...
Selecting previously unselected package libhttp-date-perl.
Preparing to unpack .../13-libhttp-date-perl_6.05-1_all.deb ...
Unpacking libhttp-date-perl (6.05-1) ...
Selecting previously unselected package libio-html-perl.
Preparing to unpack .../14-libio-html-perl_1.004-2_all.deb ...
Unpacking libio-html-perl (1.004-2) ...
Selecting previously unselected package liblwp-mediatypes-perl.
Preparing to unpack .../15-liblwp-mediatypes-perl_6.04-1_all.deb ...
Unpacking liblwp-mediatypes-perl (6.04-1) ...
Selecting previously unselected package libhttp-message-perl.
Preparing to unpack .../16-libhttp-message-perl_6.36-1_all.deb ...
Unpacking libhttp-message-perl (6.36-1) ...
Selecting previously unselected package mecab-utils.
Preparing to unpack .../17-mecab-utils_0.996-14build9_amd64.deb ...
Unpacking mecab-utils (0.996-14build9) ...
Selecting previously unselected package mecab-ipadic.
Preparing to unpack .../18-mecab-ipadic_2.7.0-20070801+main-3_all.deb ...
Unpacking mecab-ipadic (2.7.0-20070801+main-3) ...
Selecting previously unselected package mecab-ipadic-utf8.
Preparing to unpack .../19-mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb ...
Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../20-mysql-server_8.0.32-0ubuntu0.22.04.2_all.deb ...
Unpacking mysql-server (8.0.32-0ubuntu0.22.04.2) ...
Setting up libmecab2:amd64 (0.996-14build9) ...
Setting up mysql-client-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up libfcgi0ldbl:amd64 (2.4.2-2build2) ...
Setting up libclone-perl (0.45-1build3) ...
Setting up libhtml-tagset-perl (3.20-4) ...
Setting up liblwp-mediatypes-perl (6.04-1) ...
Setting up libfcgi-bin (2.4.2-2build2) ...
Setting up libencode-locale-perl (1.05-1.1) ...
Setting up libprotobuf-lite23:amd64 (3.12.4-1ubuntu7) ...
Setting up mecab-utils (0.996-14build9) ...
Setting up libio-html-perl (1.004-2) ...
Setting up libtimedate-perl (2.3300-2) ...
Setting up mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up libfcgi-perl:amd64 (0.82+ds-1build1) ...
Setting up liburi-perl (5.10-1) ...
Setting up libevent-pthreads-2.1-7:amd64 (2.1.12-stable-1build3) ...
Setting up libhttp-date-perl (6.05-1) ...
Setting up mecab-ipadic (2.7.0-20070801+main-3) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################|

done!
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up mysql-server-core-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################|

done!
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up libhtml-parser-perl:amd64 (3.76-1build2) ...
Setting up libhttp-message-perl (6.36-1) ...
Setting up mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...
invoke-rc.d: could not determine current runlevel
 * Stopping MySQL database server mysqld                                                                             [ OK ]
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 30381
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
invoke-rc.d: could not determine current runlevel
Setting up libcgi-pm-perl (4.54-1) ...
Setting up libhtml-template-perl (2.97-1.1) ...
Setting up mysql-server (8.0.32-0ubuntu0.22.04.2) ...
Setting up libcgi-fast-perl (1:2.15-1) ...
Processing triggers for man-db (2.10.2-1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
/sbin/ldconfig.real: /usr/lib/wsl/lib/libcuda.so.1 is not a symbolic link

Scanning processes...
Scanning processor microcode...
Scanning linux images...

Failed to retrieve available kernel versions.

The processor microcode seems to be up-to-date.

No services need to be restarted.

No containers need to be restarted.

No user sessions are running outdated binaries.

No VM guests are running outdated hypervisor (qemu) binaries on this host.

try to run the mysql CLI to change password for root:

/usr/bin/mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket

What is the problem and how I can fix it?

I am trying to prepare a WordPress site, on my public web server, running apache2. The database host, I am trying to use, for the WordPress installation, is another server. While I can successfully connect the db_host from my web server, through MySQL client, WordPress configuration can not connect the database. Though mysql_client works from the same machine Please help me

I opened mysqld_safe for some reason in Linux but now I can't completely exit or kill it! Closing the terminal didn't help. Then I tried with kill -9 and I killed 2 processes but can't kill the last one. This is from WSL though, I tried Parrot OS also and the result was same as this one.

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ ps aux | grep mysqld_safe
root       120  0.3  0.0  18036  2804 ?          S   18:31  0:00 sudo mysqld_safe
root       121  0.2  0.0  10460   780 ?          S   18:31  0:00 /bin/sh /usr/bin/mysqld_safe
dr-ph4n+   284  0.0  0.0  14292  1224 ? tty2     S   18:32  0:00 grep --color=auto mysqld_safe

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ sudo kill all mysqld_safe
[sudo] password for dr-ph4ntom:
kill: failed to parse argument: 'all'

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ sudo killall mysqld_safe                                                                                         1�

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ ps aux | grep mysqld_safe
root       120  0.0  0.0  18036  2784 ?          S   18:31  0:00 sudo mysqld_safe
root       121  0.0  0.0  10460   780 ?          S   18:31  0:00 /bin/sh /usr/bin/mysqld_safe
dr-ph4n+   311  0.0  0.0  14156  1008 ? tty2     R   18:34  0:00 grep --color=auto mysqld_safe

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ sudo kill -9 120 121 311
kill: (311): No such process

┌──(dr-ph4ntom� DESKTOP-HSC7AGA)-[~] 
└─$ ps aux | grep mysqld_safe                                                                                       1�
dr-ph4n+   320  0.0  0.0  11264   804 ? tty2     R   18:35  0:00 grep --color=auto mysqld_safe

Now can you please help me by telling how to solve this problem… I am a newbie both in Linux and StackExchange…

Firstly I text the command on my terminal like sudo /opt/lampp/lampp start sudo /opt/lampp/lampp start [sudo] password for tayef: Starting XAMPP for Linux 7.2.34-0... XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...ok. XAMPP: Starting ProFTPD...ok. Secondly I text like sudo /opt/lampp/manager-linux-x64.run sudo /opt/lampp/manager-linux-x64.run After doing that of above xampp GUI comes like..please, click picture link below then After click on Xampp home panel on Go To Application it shows like the following Running Firefox as root in a regular user's session is not supported. ($XAUTHORITY is /home/tayef/.Xauthority which is owned by tayef.) [11635:11635:1106/191936.161137:ERROR:zygote_host_impl_linux.cc(90)] Running as root without --no-sandbox is not supported. See https://crbug.com/638180 . Running Firefox as root in a regular user's session is not supported. ($XAUTHORITY is /home/tayef/.Xauthority which is owned by tayef.) /usr/bin/xdg-open: 869: iceweasel: not found /usr/bin/xdg-open: 869: seamonkey: not found /usr/bin/xdg-open: 869: mozilla: not found /usr/bin/xdg-open: 869: epiphany: not found /usr/bin/xdg-open: 869: konqueror: not found /usr/bin/xdg-open: 869: chromium: not found /usr/bin/xdg-open: 869: chromium-browser: not found [11665:11665:1106/191936.206660:ERROR:zygote_host_impl_linux.cc(90)] Running as root without --no-sandbox is not supported. See https://crbug.com/638180 . /usr/bin/xdg-open: 869: www-browser: not found /usr/bin/xdg-open: 869: links2: not found /usr/bin/xdg-open: 869: elinks: not found /usr/bin/xdg-open: 869: links: not found /usr/bin/xdg-open: 869: lynx: not found /usr/bin/xdg-open: 869: w3m: not found xdg-open: no method available for opening 'http://localhost:80'

I'm new to databases and have some very basic how-to/where-to questions: 1. I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database with a couple of columns, which works like a charm. 2. Now, under Windows, I would like to import the data into Matlab, using adodb_connect(), created by the community (link ), to analyze some data that I stored in the database. From the docs of that file: > Package adodb_toolbox allows communication with different types of databases through Microsoft's ADO (ActiveX Data Objects) OLEDB component. The package was designed to work on Microsoft SQL Server, Oracle, Microsoft Access, MySQL and other databases. However I can't find good and straightforward guide on how to install ODBC on my raspberry pi (as far as I understand MariaDB should, for all intents and purposes, classify as a 'MYSQL database'), this usually means I'm not following the most common implementations anymore, which is why I'm asking for some general questions (after reading/googling): - Would you (e.g. a poweruser or expert) have advice on a more straight forward option to import the data to Matlab (or even Java, or even Windows) from my SQL database rather than this OLEDB interface? (the goal here is to make the database as accessible as possible) - Is there a good guide or resource I should follow to install this (database connector or whatever would be more advisable) on my raspberry pi? thanks!

what happens if I use this command? sudo dpkg-reconfigure mysql-server and more important : what happens to my databases? Are they droped? note: when I upgraded my ubuntu 16.04 in last night , changed some settings that I modified , then I can't connect to mysql when I try to connect db, i see this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Thanks!

I have a problem, I need to give an access to someone, but the only way to connect to the database is via SSH, so if I have understood everything correctly, I need to create him a linux account (on a Debian 10 machine), the user created doesn't have any right to write in folder, so I guess he can't break anything. But the problem is that he can read any file in the filesystem, I don't really know what is the best practice, I know chmod could fix everything but I don't know if it is a good practice to remove all rights from others and changing the group of every single file to my main linux account. I guess I should remove all the execution rights of the command under the /bin folder and change the group of the file? Thanks for reading! I hope I was clear.

What is the difference between 1. sudo apt-get install mono-runtime and 2. sudo apt-get purge --remove mono-complete followed by sudo apt-get install mono-complete on an Ubuntu linux 16.04 instance? I was told earlier today that the difference between mono-runtime and mono-complete could be related to whether MySQL inserts successfully take place in favor of mono-complete. Another hypothesis is that the the difference between mono-runtime and mono-complete could be related to the Mono implementation of System.Windows.Forms.dll with respect to responding to button clicks or presses which start MySQL database manipulation operations(i.e. DML). I have used strace before. So I could post snippets of strace output upon request. In some quarters, sudo apt-get install mono-complete means install the Mono Rumtime environment. But that is not what I mean here.

I wanted to connect to memsql but when I try i wasn't able to connect , I get error as: ~~~ mysql -u root -h 127.0.0.1 -P 3306 --prompt="memsql> " ERROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115) ~~~ Even for the local host I get the same error when I try to install: ~~~ sudo apt-get install mysql-server mysql-client Reading package lists... Done Building dependency tree Reading state information... Done Package mysql-client is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source Package mysql-server is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'mysql-server' has no installation candidate E: Package 'mysql-client' has no installation candidate ~~~ Suggestions would be much appreciated

When i try to execute a query i got error: MariaDB [suitecrm]> select * from waiter_log; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... An error does not occur every time: MariaDB [suitecrm]> select count(*) from waiter_log; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 64418348 Current database: suitecrm +----------+ | count(*) | +----------+ | 893 | +----------+ 1 row in set (2.13 sec) MariaDB [suitecrm]> select count(*) from waiter_log; +----------+ | count(*) | +----------+ | 893 | +----------+ 1 row in set (0.00 sec) ***/etc/my.cnf*** max_allowed_packet = 128M interactive_timeout=20 wait_timeout=20 Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1

Trying to connect to a database with a c++ program. I am using the [mysqlcppconnector](https://dev.mysql.com/downloads/connector/cpp/) with the connection strings tcp://localhost:3306 and tcp://127.0.0.1:3306. The program works on my local machine, but when I try to run it on my remote ubuntu server after ssh'ing in, it complains: terminate called after throwing an instance of 'sql::SQLException' what(): Unknown MySQL server host 'tcp' (2) I'm just trying to connect on localhost, at the default port 3306. I can also connect manually by typing in mysql -u root -p and just logging in that way. After logging in to my database with mysql -u root -p, I can type show variables; and indeed I see skip-networking set to "OFF". MySQL is listening on the network: netstat -a | grep mysql tcp 0 0 localhost:mysql 0.0.0.0:* LISTEN unix 2 [ ACC ] STREAM LISTENING 20025 /var/run/mysqld/mysqld.sock Is there some configuration that I forgot to change? What does the "(2)" mean?

I am attempting to daisy chain tunnels/ports to access mysql on a secured server. Without opening up iptables, I would like to, from my local machine: mysql -uadmin_user -p -hlocalhost:8002 and have it jump ssh tunnel connections through to the servers ultimately to remote2.private-ip:3306 as described in my set-up screenshot. My set up is like this: I had been trying this for a while, and I gave up with the 3 way hop for now and I have been attempting to get it working with 1 and remote 2 connected first. I still can't get that to work yet either. Then I went to remote2 and I can't get the tunnel to work on remote2-private either. Initially I used remote2: ssh -f -N -M -S ~/.ssh/sockets/remote2-private-tunnel.sock -t -A -R 8002:localhost:3306 user@remote2.private-ip And then I tried: remote2:ssh -f -N -R 8002:remote2.private-ip:3306 remote2.public-ip And with both of those, I cannot from remote2: remote2: mysql -uadmin_user -p -hremote2.public-ip:8002 I can tell it is not getting to the mysql server because I get the error ERROR 2005 (HY000): Unknown MySQL server host 'remote2.public-ip:8002' (0) instead of something similar like: ERROR 1045 (28000): Access denied for user 'admin_user'@'remote2.private-ip' (using password: YES) I feel like I am just overwhelmed here and am missing something simple that I should be seeing. Any help would be much appreciated. I should note, SSH keys are being used, and connectivity is established ssh'ing to them normally. Also, normal mysql connection to remote2.private-ip is also working. Also remote1 and remote2 are both joined on private networking and mysql from remote1.private-ip CLI to host remote2.private-ip works as well.

my new production server is only visible via ssh double tunnel. I can reach **targetHost** over Ubuntu's 14.04 console simply executing command ssh targetHost and than executing mysql cli on remote machine but I'd like to get to MySQL db over gui Workbench. How to configure connection in Workbench to achieve it? My **.ssh/config**: Host targetHost, firewallHost User username IdentityFile /home/michalszulc/.ssh/id_rsa Host targetHost proxycommand ssh -W %h:%p firewallHost Host firewallHost hostname firewallHost.example.com port 2201 passwordauthentication no controlmaster auto controlpath ~/ Host targetHost Hostname 123.123.123.123

I have had install Damn small Linux(DSL) 10 in Virtual Box with MySQL 5. I created already a database with a Table and Data in it. I can access it over the terminal with the following line: mysql -u dsl During this, DSL is startes with startx (GUI). But if I start DSL without startx (its not anymore in .bash_profile) I'll get access to DSL over the Terminal (tty1) automatically. The Problem at this point. If DSL started without startx, its not possible to get access to Mysql by give in the line: mysql -u dsl The Screenshot is here: How its possible to solve this problem.