[00:01] matsaman: (Not trying to restart our debate over software installation, but I am sorry for the tone I used, and I'm also sorry for some of the confusing stuff I said (particularly over "compiling software" - I get why you said, no, that kills your system, and you're right, I was using a different meaning of "compile software" there). I'll try to not go so fast in the future. I had kind of a bad day and got a bit out of sorts.) [00:05] Bye everyone (it's 2:05 am here ... [00:09] arraybolt3[m]: oh think nothing of it, as far as I'm concerned [00:22] matsaman: Thanks. I don't want to be like that. Thank you for your patience and forgiveness. === Starmina1 is now known as Starmina === arhue6 is now known as arhue === BadAtom_ is now known as BadAtom [01:09] hi all.is there a way to make a driver persistent after an update ? [01:26] No. [01:27] Probably not anyway. It's hard to understand the question. [01:28] There's things like DKMS that can be useful.... [01:29] coz the driver for the wifi is not native to ubuntu18,did manual install via dkms & is working fine,but whenever there is an update it cant be detected again & i have to redo the manual installation,so is there a way to make it persistent after an update [01:36] Err:6 http://ppa.launchpad.net/duh/duh/ubuntu focal Release 404 Not Found [IP: 185.125.190.52 80] [01:36] how do I upgrade now? [01:36] this must be optional though [01:37] try again [01:40] nopes it gives 404 [01:40] grepped /etv/apt/* ... it does not have a launchpad.net at all [01:41] Any secondary configurations could give it? [01:41] That site is in fact responding to me. [01:41] Dunno why its not for you. [01:42] so maybe reboot? [01:42] But your sources are in /etc/apt/sources.list and /etc/apt/sources.list.d [01:42] launchpad is run by canonical, it should be reliable [01:42] !upgrade [01:42] For upgrading, see the instructions at https://help.ubuntu.com/community/UpgradeNotes - see also http://www.ubuntu.com/desktop/get-ubuntu/upgrade [01:43] Jari--: Try reading the instructions. [01:56] well [01:56] if ubuntu made an update ,does the generic kernel on dkms install is also updated? [01:56] I did a apt dist-upgrade [01:56] now its okay [01:57] thats what the guys at https://askubuntu.com/questions/65911/how-can-i-fix-a-404-error-when-using-a-ppa-or-updating-my-package-lists told me to do [02:00] ppa works ok on the most recent distributions available [02:00] here [02:32] hi [02:43] Ubuntu says this current hardware is supported until 2025. Nice one. Old machine though :) HP rules. [02:46] Yeah, HP ia alright, unless you deal with the rack servers :/ Then it's all "Here's the specs the server has, oh, but you can't use any of them until you pay a subscription", "You want another HDD? sure, but it has to be an overpriced version cause we check the serial number of drives and disable ones that don't match our allow list" [02:47] And Intel is doing the same thing, "here is out latest CPU, but all of the features have been disabled until you 'unlock' them via a subscription" === kaiseisei1 is now known as kaiseisei === kaiseisei1 is now known as kaiseisei === route-bee_ is now known as routebee === svip_ is now known as svip === LabMonkey is now known as Mechanismus === tykling_ is now known as tykling [06:53] I would like to configure ufw so that I a particular system can access incoming and outgoing connections to a particular ip but is denied from connecting to any other ip how do I set up the rules? [06:56] I read some tutorials but it is not clear. [07:29] I see that ufw enable/disable does not impact the execution of the startup script. What file(s) do 'ufw enable' touch? [07:30] not sure [07:30] if was only partially successful [07:31] dagb, https://paste.opensuse.org/view/raw/1ccba191 is what I tried and a better explanation [07:31] *I was only [07:32] i disabled ufw as i've successfully been able to do the first part block all outgoing conns so even irc wont work. But I cannot get the allow server access on lan bit to work [07:32] I had a look at ufw for the very first time yesterday. SO a bit green myself. [07:32] but firewalls in general stop processing rules when they find a matching rule. [07:32] order matters [07:32] yeah never needed it but there is this special case. [07:33] dagb, so I'd need to allow that ip and then deny all other outgoing [07:33] so if a rule denies the traffic, then there was a match [07:33] so I think the default deny is matching first [07:33] that would be the general way firewalls work [07:33] yes so how would i deny all else as a rule [07:33] allow what must be allowed first, then deny all [07:35] wonder if it is "ufw deny all" or "ufw deny *" [07:35] can try it [07:36] will be disconnected for a bit can't change rules when ufw is disabled [07:38] dagb, hmm both those don't work [07:39] how do i deny all outgoing except that ip [07:39] and deny all incoming except that ip [07:40] anyway will ask again later need to run thank you so much for your guidance. [07:40] ufw allow from 192.168.200.11 proto tcp to 192.168.200.10 port 22 [07:40] and [07:41] a reverse of that [07:41] I assume [07:42] yes i think i need to allow outgoing an incoming for 192.168.100.11 and then deny outgoing and incoming [07:42] bit will ask again later thank you I don't have a bnc [07:42] *but === irc is now known as amoros [07:48] hi there [07:52] hello 👋 [08:10] hello [08:10] Hello! [08:10] wow [08:11] somebody else in there ? [08:13] There are 1077 of us here [08:13] I was here yesterday, I didn't get nvidia drivers to work. I booted Lubuntu through Live USB and Nouveau are working fine here lol [08:14] I don't know why they are not working in Ubuntu 20.04 [08:15] Lubuntu 20.04 and Ubuntu 20.04 should be using the exact same driver versions [08:15] Yeah [08:15] Everything is working in Lubuntu 20.04 [08:16] I can't access my Ubuntu 20.04 root partition from this Live boot, is it not possible? [08:16] I'm able to access my home directory [08:17] I'm getting permission denied when I try to open root folder [08:20] is it possible to repair driver issue using live usb? [08:22] which kernel version is it using? uname -r in a terminal [08:22] 5.4.0-42-generic [08:22] I had made this live boot usb two years back [08:23] I had kept it for use in such cases [08:23] so it's not using the hwe kernel. Perhaps try having the installed system use the 5.4.x kernel instead of the 5.13(?) or whatever the hwe kernel version is at [08:24] no wait. 5.4.x ... that sounds like 18.04 [08:24] Kernel version upto 5.8 are available in advanced boot menu [08:25] No, it is Lubuntu 20.04 [08:26] Aha I now see it has several 5.x versions, including 5.4. Never noticed that before [08:28] @geihra It's okay, I'll reinstall the OS itself [08:28] seems a bit drastic. [08:28] I'd try installing and using the 5.4 kernel [08:30] I don't know how, I'm already wasting your time here since yesterday.. I feel bad for doing that.. [08:31] apt install would work for kernel? [08:32] http://archive.ubuntu.com/ubuntu/pool/main/l/linux-hwe-5.4/ there are these available [08:33] webchat47: https://wiki.ubuntu.com/Kernel/LTSEnablementStack [08:33] webchat47: can you summarize the main issue? E.g. you've install nvidia drivers and something went wrong and now you want to uninstall them? [08:34] webchat47: and weird you have 5.4, Lubuntu should be 20.04.4 LTS pointrelease with the 5.13 kernel [08:34] i bet you downloaded the wrong iso [08:35] Installing 20.04 or 20.04.1 and updating gets you 5.4 kernel [08:35] It's showing 20.04 on wallpaper [08:35] While installing 20.04.2 and up gets you 5.13 [08:35] This is an old usb live boot [08:35] So it depends on the initial .iso you used; 5.4 is fine if you installed using the original iso [08:35] 2 not the latest one [08:36] Ah you're checking the iso kernel, not the disk kernel? Why do you care about that? [08:38] alkisg: he's trying to repair his Ubuntu install, scroll back up [08:38] Maik: AFAIK he's continuing from yesterday; I really don't want to read all of yesterday's logs :D [08:39] From what I understood his ubuntu installation has issues with nvidia, but what issues... [08:39] @alkish I tried to install webcam driver on ubuntu 20.04 my main os, installation failed and it somehow changed my display settings and my external monitor was running at lower resolution and HDMI was not getting detected. Then we found out there were multiple Nvidia drivers on my system, so I removed all of them and installed one driver. That didn't work and gde.service is not starting and I can only access system through tty. [08:40] webchat47: in grub, if you select advanced > recovery mode, and then "resume boot", does it give you a graphics login? [08:40] (that adds nomodeset so it should use vesa graphics) [08:41] I tried and It crashed during on page where it shows "resume", then I had exit and boot regular way [08:42] webchat47: isn't it better to just re-install Ubuntu.... [08:42] Yeah, I've decided to do that now. I'm trying to take backup of my files [08:42] ok :) [08:43] I'm not able to access root folder of my main os partition, it's giving permission denied error [08:43] why are you even trying to access the root folder [08:44] I have a file in root folde I need to take its backup [08:44] i see [08:47] How can I take backup of my softwares and app data? [08:50] I have these folders https://imgur.com/a/tAOcVv7 in my main os partition, which all folder do I have to take backup? [08:51] i suggest to start from scratch [08:51] ohh [08:51] okay [08:52] taking a backup of the root folders of a messed up install and putting them back on a fresh install messes up the system again [08:53] I'll leave root folder [08:53] just re-install ubuntu and don't mess around with it too much [08:53] I'll take backup of home folder it contains my files [08:54] what is the fast way to take backup of 80GB Home folder backup? [08:54] I don't to corrupt any files [08:54] want* [08:58] webchat47: cp -a /home/user /path/to/backup [08:58] live boot is not detecting my external hard drive [08:58] webchat47: it doesn't show up in 'sudo parted -ls' ? [08:59] No [09:00] make sure the backup dir is on a sane filesystem. E.g not (ex)FAT or NTFS [09:02] webchat47: try to unplug and plug it in a different usb port [09:02] webchat47: you can open a terminal and type "dmesg -w" and another with "udevmon monitor" to see if anything is being picked up [09:02] I'll tried, led on HDD lights up. but it won't get detected [09:03] webchat47: is the external HDD formatted in NTFS? [09:04] yes [09:05] It was being used for windows [09:05] dmesg shows nothing [09:05] sudo apt install ntfs-3g [09:05] log out and back in after that [09:05] it should show up in parted as a device though [09:06] webchat47: anything in udevmon? [09:06] how to check udevmon? [09:07] type "udevmon monitor" then plug the hdd [09:08] udevmon not found [09:08] I'm not Lubuntu 20.04 Live boot [09:08] on* [09:08] webchat47: try what i suggested [09:09] webchat47: sorry, udevadm monitor [09:09] @Maik it doesn't show up in sudo parted -ls [09:10] nothing shows up when in udevadm monitor [09:11] webchat47: did you do: sudo apt install ntfs-3g [09:11] no [09:11] as i said do that and log out and back in after that [09:12] okay I'll try [09:12] please try to keep up with what's suggested [09:12] okay [09:13] ntfs-3g is already installed [09:13] I'll try logout and login [09:13] no need to [09:13] okay [09:14] try sudo apt install exfat-utils and log out and in again [09:14] okay [09:14] Maik: it's not even detecting the hdd in linux [09:15] there's no /dev file to mount using any fs type [09:15] he's on a live session but shouldn't matter [09:15] I logged out and all my session got wiped 😅 [09:16] Still it didn't recognise my HDD [09:16] darshan: try different usb port i guess [09:16] darshan: could you please stick to one nick? It's confusing when providing support. [09:17] Okay sorry [09:17] I'll restart and check once [09:20] restarting the live session makes you lose everything again... === sophie0 is now known as sophie === thegodsq- is now known as thegodsquirrel [10:08] dagb, I figured it out I think. === stan is now known as Guest7155 [10:37] brandoneliza: great [11:04] Hi all [11:35] is there a concise book on ubuntu? (i used to be a linux dev but it has been like 20 years ago now, i want to get up to speed with things like new services systens etc) [11:36] !manual [11:36] The Ubuntu Manual will help you become familiar with everyday tasks such as surfing the web, listening to music and scanning documents. With an emphasis on easy to follow instructions, it is suitable for all levels of experience. http://ubuntu-manual.org/ [11:36] we used to have /etc/init.rd stuff but now it seems it's all replaced with new kernel security policies etc. so i want a book to quickly get up to speed. a book that is not written for newbies to be honest [11:37] engin & lotuspsychje ; alas the Ubuntu Manual project failed to get volunteers to update it; so it's still Unity 7 & not the current GNOME [11:37] oh right [11:37] also i find gnomes simplicity philosophy is gone way too far? [11:38] there used be KDE that is very customizable, bloated and slow [11:38] and gnome. atm, in Polaris (gnome's recommended IRC) there's no way to enter advanced settings to set up a BNC. Also recommended mail app doesn't have an option to list only unread mail. [11:38] am i doing something wrong. is this is the current state of affairs? [11:39] engin, KDE using Qt5 is actualy lighter/faster (generally) than GTK3 used by current GNOME... KDE4 is what was slow; the complaints were heeded by Qt & KDE4 was improved (lightended) then replaced with faster/lighter Qt5 [11:40] noted [11:40] and most people won't actually use most of the gnome applications, but just the desktop itself. [11:58] ih [12:01] tomreyn: ? [12:01] leftyfb: ? [12:01] the last post here? Ban evading troll [12:02] US YBYTY##] [12:03] scortal1: please stop [12:03] i mikey [12:04] tomreyn: if you're around mind doing the honor ^ [12:04] hi tomreyn [12:07] Hi, every [12:12] Is "LivePatch" supposed to be able to update the kernel with out rebooting or am I smoking crack? === pah is now known as pa [12:15] !livepatch | rjwiii [12:15] rjwiii: Canonical Livepatch is a service offered by Canonical for 64 bit 14.04 and higher installs that modifies the currently running kernel for updates without the need to restart. More information can be found at https://ubottu.com/y/livepatch and https://www.ubuntu.com/server/livepatch [12:29] rjwiii: livepatch patches the kernel running in memory until you reboot, at which time you're now running the regularly updated kernel [12:32] leftyfb: I hate having to reboot ... [12:41] Hi all, is it possible to get a version log of an apt package? I don't just want the current version number, I want to know how often upgrades are being made. [12:42] jmft2: perhaps the dpkg logs can help you? [12:43] but that would only show the versions from your current install [12:44] lotuspsychje: right, that's not what I need, I need to know how often the developers are releasing new versions [12:45] https://packages.qa.debian.org/common/index.html good starting point [12:45] This gives timestamps: less /var/log/apt/history.log [12:48] Elliria: yes, but this is only for packages that I have installed and am updating [12:50] I've been googling, and haven't seen anyone with this issue, so I thought I'd check here. I upgraded to 22.04, but my computer keeps crashing back to the login screen. 1. It leaves things like ssh tunnels open, so ports are still in use, but I can't access them anymore. 2. It seems to happen when I get to a certain level of RAM usage. 3. I can reliably recreate it by opening a 98mb image in GIMP. [12:53] I'm not sure if this is what you're after, jmft2, but I've collected these links for use in finding out specifics about packages: https://pastebin.com/WR4w6e1A [12:53] deltreey, what about your swap size ? [12:54] Just curious, deltreey, but is wslu installed? [12:56] In Kubuntu, the gimp-help-en package automatically installs wslu, which stops all shortcuts from working and turns my operating system into a brick (this has been reported as a bug). Perhaps it behaves differently in Ubuntu? [12:57] ioria, Swap: 2097148 15872 2081276 [12:57] Elliria, which wslu returns nothing [12:58] deltreey, heavily in use [12:59] strange [12:59] deltreey, how much ram ? [12:59] ioria, Mem: 15957948 4221644 6499032 799884 5237272 10598912 [13:01] deltreey, run 'vmstat 1' and see if there 's some 'si so ' activity [13:01] ioria, one row has it [13:01] 4 0 17664 6436476 418728 4626616 2 214 739 561 657 1220 19 3 76 2 0 [13:02] si 2, so 214 on that row [13:05] deltreey, try this cmd to check which process is using it : for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{ print ""}' $file; done [13:06] ioria, there's a lot of output here, what am I looking for? [13:06] deltreey, you look for the number after the proc name [13:08] deltreey, btw, there an ongoing issue with systemd-oomd on 22.04 [13:12] deltreey, you can increase the swap size or disable that service [13:15] the largest is dockerd, at about 2k kb [13:15] that systemd-oomd sounds like what I'm dealing with [13:15] turning it off, thanks for the tip [13:15] ok [13:16] How much RAM a normal Ubuntu O.S. needs ATM once booted? [13:16] carillons0: how long is a fish? [13:19] Who is Russian? [13:19] Who is Use Linux Mint? [13:20] !mint | matvei [13:20] matvei: The Ubuntu channels can only provide support for Ubuntu and its official flavors, since other distributions and derivatives have repository and software changes. So please use their dedicated support venues, for example: Linux Mint (#linuxmint-help on irc.spotchat.org), Kali Linux (#kali-linux), and LXLE (#lxle) === pihahiroth is now known as spammy [13:31] well, that was fun [13:32] ok, so systemd-oomd was definitely kicking me out of my session, but apparently the problem is bigger than that because with systemd-oomd stopped, my whole computer would just lock up (when doing the things that would have caused it to crash my session) [13:32] ioria, thanks for the info. Not sure where to go from here [13:41] matvei: what is your question? [13:45] any recommended memory testing tools? Maybe I have something wrong with my RAM [13:46] deltreey, https://www.memtest86.com/downloads/memtest86-4.3.7-iso.tar.gz [13:46] in kde system tray, under "battery and brightness" there's an option that prevents sleep "manually block sleep and screen locking". How do I achieve the same using terminal? I want it as a keyboard shortcut. [13:57] hi all === ctrlbreak_MAD is now known as ctrlbreak === enyc_ is now known as enyc [14:40] deltreey, you can change the limit in the unit service file [14:46] memtest86 still a thing? [14:46] jhutchins: on bios systems yes [14:46] but afaik there is an update for uefi [14:47] the one ravage pointed to [14:48] ah no, that's the bios one [14:48] https://www.memtest86.com/downloads/memtest86-usb.zip is uefi [14:48] the website also has version 9 that supports uefi [14:48] but only a usb zip. found no iso [14:50] "Changes in v8.0 (December/2018): Removed MemTest86 ISO download packages. Users are encouraged to use the USB boot images which allow logs, reports and configuration files to be written to the USB drive. If CD boot is required, please use ISO images from MemTest86 v7 or earlier." [14:52] which really sucks. USB storage is not allowed in a lot of environments with servers. so a bootable read-only CD/DVD would be really nice [14:52] you can pxe boot though [14:52] right [14:53] but not every customer has that setup when he asks for a memtest :) === polve2 is now known as polve [15:25] I'm trying to take a backup of an LVM snapshot of a running system. I can create the snapshot and mount it with `lvcreate -L5G -s -n backup /dev/ubuntu-vg/ubuntu-lv`, but when I try to merge it back with `lvconvert --merge /dev/ubuntu-vg/backup` it says Delaying merge since origin is open. Merging of snapshot ubuntu-vg/backup will occur on next activation of ubuntu-vg/ubuntu-lv. Am I missing a step here? [15:28] https://askubuntu.com/a/680451 indicates a reboot is necessary, too, but is that only to discard changes? I want to keep all changes, just need a stable system for the backup === polve2 is now known as polve [15:36] should I just delete the snapshot `lvremove /dev/ubuntu-vg/backup`? "Do you really want to remove and DISCARD active logical volume ubuntu-vg/backup?" === root is now known as Guest1869 [16:07] ravage: There are ISO images for V7. These do not include the persistent features of later versions - which I suspect is the major difference in the later versions. Why do you have to have the latest one? [16:10] i never said i do. usually servers still have a legacy boot option [16:11] that's why I linked the older iso [16:18] When I 'M installing mysql I get the following SOLVED – Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. [16:21] Is anyone there [16:22] webchat94: Why are you asking us about the instructions your MySQL system is giving you? [16:22] Because I want to use mysql [16:22] And I tried everything [16:23] webchat94, https://askubuntu.com/questions/1406395/mysql-root-password-setup-error [16:23] webchat94: Did you try using ALTER USER? [16:23] i tried googling :) [16:23] webchat94, what guide do you folow? [16:23] oh [16:24] Are there any solutions [16:24] ok. im out :D [16:24] sure, but we cannot copy paste all the commands [16:25] read back, ravage might gave your fix [16:25] https://www.google.com/search?q=oreilly+mysql&oq=oreilly+mysql&aqs=chrome..69i57j0i10l2j0i10i22i30j0i22i30l2j0i10i15i22i30j0i10i22i30j69i64.7175j0j7&sourceid=chrome&ie=UTF-8 [16:26] I was going to say O'Reilly has a book, it turns out they have several. [16:26] I was going to say O'Reilly has a book, it turns out they have several. [16:27] webchat94: What are you actually trying to do with your SQL server? [16:27] sudo mysql_secure_installation .. and see step 3; https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04 [16:27] so many guides .. [16:27] Pretty much anything that uses MySQL as a back end has step-by-step instructions for setting up the DB. [16:30] Now webchat94 , register your name with Libera, and login :-) .. that is if you take our support seriously. [16:30] Yes I did mysql_secure_installatiation and they I got the error [16:33] I did this and then I got the error [16:34] webchat94: Did you try looking up "ALTER USER" in the online command index to learn the syntax? [16:34] Yes I did everything and it still doesn't work [16:35] it is not an error, just a warning [16:35] webchat94: Of course it doesn't work, you're trying to do something that doesn't work. [16:36] Can you join. A call and help me [16:36] webchat94: We are very sceptical that you tried "everything". [16:36] webchat94: No, a call won't do any good if you can't follow simple instructions. [16:36] People have asked you several questions, like what is the SQL server for, and you haven't answered anything. [16:37] I followed all the toturuals I found online and it still doesn't work [16:37] I even tried generating A password using a password generator [16:38] webchat94: That's because, as the message indicates, you're trying to do something that can't be done. [16:38] What can I do [16:38] webchat94: ALTER USER instead of SET PASSWORD. [16:39] webchat94: Answer the questions people here have asked you. [16:39] I used alter user many times it doesn't work [16:41] how could you tell "it does not work"? that's the most unspecific response you can give. were there error messages, did something (what?) not work as expected (what was expected) afterwards? [16:41] mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '************************d'; [16:41] and ' exit' [16:41] It said it doesn't match policies [16:42] I did that [16:42] webchat94: That means your password doesn't meet the requirements (which you can set). [16:43] I tried many password but I didn't work [16:43] webchat94: Did you try looking up the password requirements? [16:43] too short, i capital, 1 number, one special character.. [16:44] webchat94: There, oerheks has done it for you. [16:44] Yes it was set to medium [16:44] oerheks: Seems to me like it's 8 characters. [16:44] 12345ABCDEFG!@# is an easy test. [16:44] oerheks: Doesn't it need one lower case? [16:44] better more than 32 characters, to avoid rainbowtables [16:44] oh good spot, jhutchins [16:45] The policy was set to medium [16:45] webchat94: You could look at the on-line documentation and see what "medium" actually means. [16:46] webchat94: If it says it doesn't match the policy, that's what it's talking about. [16:46] I did that [16:46] webchat94: Also make sure you're using the right quotes. [16:46] The policy was set to medium [16:46] webchat94: Yes, you've said that several times. [16:47] webchat94: https://kb.iu.edu/d/aphg [16:47] So I generated many password according to the policy but I didn't work [16:47] then show us the full log on paste.ubuntu.com ? [16:47] !info mysql [16:47] Package mysql does not exist in jammy [16:48] !info mysql-server [16:48] mysql-server (8.0.29-0ubuntu0.22.04.2, jammy): MySQL database server (metapackage depending on the latest version). In component main, is optional. Built by mysql-8.0. Size 10 kB / 108 kB [16:48] mysql-server [16:49] You want a screen shot [16:50] https://linuxhint.com/install_mysql_ubuntu_20-04/ [16:50] I 'M on Ubuntu 22.04 [16:50] no screenshots please, paste the text [16:50] webchat94: So is that page, actually. [16:50] so lame, screenshots [16:51] Can anyone just join me on a call and help please a discord call [16:52] I think my last inventory was ~234 MySQL servers, most of them upgraded to Percona 8, but a few malingering at MySQL5. [16:53] webchat94: Yes, my community rates are $75US/hr with a three hour minimum. [16:53] webchat94: Or you could just answer the questions and follow the suggestions here. [16:53] Find give me the questions [16:54] webchat94: Look through the scrollback. What is the server for? [16:54] *fine [16:54] Setup up databases [16:55] I did secure_installation [16:55] webchat94: There are lots of guides out there, that's part of the problem. You need to follow ONE guid that's specific to the release and version you have. [16:55] I did follow those guide [16:55] webchat94: Do you not understand that SET PASSWORD is never going to work, you must use ALTER USER, with a password that meets the medium requirements, and the right quotes in the right places. [16:56] webchat94: Why not just use the current root password as it is? [16:56] I don't know the password [16:57] For root I just want to secure mysql [16:57] webchat94: Obviously you're setting up databases, that's what MySQL is! What are the databases for? [16:57] Just for testing and practicing comabss [16:58] Commands [16:59] I imagine it is already secure, only root can login using a shell. I think more recent mysql versions on ubuntu work like that [16:59] I tried alter user with a random password generator but j didn't work [16:59] It didn't work [17:00] 20% of the database market is MySQL. It's not the software's fault. [17:00] webchat94: You are stuck in a fail loop. You need to put this down, do something else for a while, let your brain rest. [17:01] webchat94: Clean your room, wash the cat, vacuum the lawn, just get away from the computer for a while [17:01] I'm out of coffee. [17:02] Well should I reinstall mysql [17:02] Cause I did alter user many times [17:02] I didn't work [17:03] And you said something about the correct commas what does that mean [17:04] Y'know, if he's using a password generator, it's probably a cut-and-paste error like a hidden character. [17:05] webchat94: I think a clean reinstall, following one single guide like the one I linked above that's specific to MySQL8 and Ubuntu, might be a good idea. [17:05] I typed in the password manually [17:05] webchat94: I still think you need to break the loop and do something else for at least half an hour. [17:06] I did that [17:06] 201 users on #mysql [17:07] Can anyone just join me on a chat and help me live [17:07] no, register and join #mysql [17:09] Ok [17:09] Can i have a guide then [17:10] https://linuxhint.com/install_mysql_ubuntu_20-04/ [17:10] And what if alter user doesn't work [17:11] I was trying to run mysql_secure_installation [17:11] Then 20% of the databases in the world will suddenly stop. [17:12] as you are testing, do a fresh install with these guides. [17:12] Then I tried alter user [17:12] if it does not work again, join mysql? [17:12]