Posts made by Pete.S

@dave_c said in Data Base Management:

@Pete-S
We were not sure they were dBase files. Even Oracle database uses .dbf extension for data files.

I understand. You can't be sure until you try but usually you'll know if you're running Oracle because you'll have oracle listener and other services running as well as a completely different folder structure. When you find files that are dbf somewhere, they're usually dBase because you can make a small database inside an application just by importing some libraries. So dBase isn't something that has to be installed on the computer but Oracle is.

There are three ways to go.

• control systems route
• security system route
• IT route

Not enough info in your post to decide the best way forward. But what you found is most likely not what you want.

@pmoncho said in HDMI Monitor suggestions:

@Pete-S said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@Pete-S said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@WrCombs said in HDMI Monitor suggestions:

Just finished Moving from Windows 7 Desktop to Windows 10 Laptop as the daily driver at work.
only thing i'm missing is my second screen and that's cause I'm missing the HDMI port on the Monitors we have here.
My Boss is going to buy what ever screen I pick out, with that said, what are your suggestions for a new monitor that is compatible with HDMI? (Which should be any recently made monitor, right? )

If going with a new monitor, I've always been partial to Dell 24" U2419H line. Nice color, crisp, clear.

If going new, I like 27" or larger.

If a single monitor, I agree 27 or larger would be the way to go. I have had 2 or more monitors for so long, it slips my brain that many will probably have one. I have found that 24" monitors hit a sweet spot with 2 or more.

I'm working with a 32", 24" and 20" right now, and wish for 3 40" monitors with how much I tend to have going on.

Dang, 3 40's would take up a lot of desk real estate. Wish I had that much desk room for those.

Virtual desktops works good for that. I set up 12 virtual desktops on my 40" monitor and switch between them with alt-ctrl+F1 up to F12 or the mouse.

The combination of large monitors and many virtual desktops causes you to work differently but more efficient. Basically you never maximize or minimize windows or use the taskbar to switch between application because there is no need to run anything in full screen. You just overlap the windows and use more virtual desktops when you need more space.

To keep my sanity I label the desktops if possible and always put certain things on certain desktops. For instance calendar, email and communication I always keep open on desktop 1. Music streaming and non-work related stuff on desktop 2. Then I have a couple of desktops where I remote into customers systems and run ssh and what not. One or two desktops where I manage our internal systems. If I need to research something I take an empty desktop and open up a browser or two there. So the desktops are kind of task related, not application related.

Are those VM's on a server or your workstation? Sounds like an interesting setup. I'm guessing they are linux desktops?

No, sorry. I actually use both VMs on a workstation and hosted this is not related to that. The "virtual desktops" are not virtual machines, just multiple desktops on the same computer.

Linux have had it for many years and you could do it on windows too for years with 3rd party software and lately with Windows 10 natively.

Oh I get it now. I believe NVIDIA had that feature. Never really used it though. Maybe I will look into it. I mainly use alt-tab anyways to get between apps. Just run into issue with RDP windows but never was a big enough deal to change.

Virtual desktops is like having many, many more monitors. But you can only view one at a time.

It works the same with multiple monitors. If I used three 24" monitors and had 12 virtual desktops I would have had 36 monitors to place windows on. But I could only view three of them at a time.

@pmoncho said in HDMI Monitor suggestions:

@Pete-S said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@WrCombs said in HDMI Monitor suggestions:

Just finished Moving from Windows 7 Desktop to Windows 10 Laptop as the daily driver at work.
only thing i'm missing is my second screen and that's cause I'm missing the HDMI port on the Monitors we have here.
My Boss is going to buy what ever screen I pick out, with that said, what are your suggestions for a new monitor that is compatible with HDMI? (Which should be any recently made monitor, right? )

If going with a new monitor, I've always been partial to Dell 24" U2419H line. Nice color, crisp, clear.

If going new, I like 27" or larger.

If a single monitor, I agree 27 or larger would be the way to go. I have had 2 or more monitors for so long, it slips my brain that many will probably have one. I have found that 24" monitors hit a sweet spot with 2 or more.

I'm working with a 32", 24" and 20" right now, and wish for 3 40" monitors with how much I tend to have going on.

Dang, 3 40's would take up a lot of desk real estate. Wish I had that much desk room for those.

Virtual desktops works good for that. I set up 12 virtual desktops on my 40" monitor and switch between them with alt-ctrl+F1 up to F12 or the mouse.

The combination of large monitors and many virtual desktops causes you to work differently but more efficient. Basically you never maximize or minimize windows or use the taskbar to switch between application because there is no need to run anything in full screen. You just overlap the windows and use more virtual desktops when you need more space.

To keep my sanity I label the desktops if possible and always put certain things on certain desktops. For instance calendar, email and communication I always keep open on desktop 1. Music streaming and non-work related stuff on desktop 2. Then I have a couple of desktops where I remote into customers systems and run ssh and what not. One or two desktops where I manage our internal systems. If I need to research something I take an empty desktop and open up a browser or two there. So the desktops are kind of task related, not application related.

Are those VM's on a server or your workstation? Sounds like an interesting setup. I'm guessing they are linux desktops?

No, sorry. I actually use both VMs on a workstation and hosted, but this is not related to that. The "virtual desktops" are not virtual machines, just multiple desktops on the same computer.

Linux have had it for many years and you could do it on windows too for years with 3rd party software and lately with Windows 10 natively.

@pmoncho said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@WrCombs said in HDMI Monitor suggestions:

Just finished Moving from Windows 7 Desktop to Windows 10 Laptop as the daily driver at work.
only thing i'm missing is my second screen and that's cause I'm missing the HDMI port on the Monitors we have here.
My Boss is going to buy what ever screen I pick out, with that said, what are your suggestions for a new monitor that is compatible with HDMI? (Which should be any recently made monitor, right? )

If going with a new monitor, I've always been partial to Dell 24" U2419H line. Nice color, crisp, clear.

If going new, I like 27" or larger.

If a single monitor, I agree 27 or larger would be the way to go. I have had 2 or more monitors for so long, it slips my brain that many will probably have one. I have found that 24" monitors hit a sweet spot with 2 or more.

I'm working with a 32", 24" and 20" right now, and wish for 3 40" monitors with how much I tend to have going on.

Dang, 3 40's would take up a lot of desk real estate. Wish I had that much desk room for those.

Virtual desktops works good for that. I set up 12 virtual desktops on my 40" monitor and switch between them with alt-ctrl+F1 up to F12 or the mouse.

The combination of large monitors and many virtual desktops causes you to work differently but more efficient. Basically you never maximize or minimize windows or use the taskbar to switch between application because there is no need to run anything in full screen. You just overlap the windows and use more virtual desktops when you need more space.

To keep my sanity I label the desktops if possible and always put certain things on certain desktops. For instance calendar, email and communication I always keep open on desktop 1. Music streaming and non-work related stuff on desktop 2. Then I have a couple of desktops where I remote into customers systems and run ssh and what not. One or two desktops where I manage our internal systems. If I need to research something I take an empty desktop and open up a browser or two there. So the desktops are kind of task related, not application related.

@scottalanmiller said in HDMI Monitor suggestions:

@Pete-S said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@WrCombs said in HDMI Monitor suggestions:

Just finished Moving from Windows 7 Desktop to Windows 10 Laptop as the daily driver at work.
only thing i'm missing is my second screen and that's cause I'm missing the HDMI port on the Monitors we have here.
My Boss is going to buy what ever screen I pick out, with that said, what are your suggestions for a new monitor that is compatible with HDMI? (Which should be any recently made monitor, right? )

If going with a new monitor, I've always been partial to Dell 24" U2419H line. Nice color, crisp, clear.

If going new, I like 27" or larger.

If a single monitor, I agree 27 or larger would be the way to go. I have had 2 or more monitors for so long, it slips my brain that many will probably have one. I have found that 24" monitors hit a sweet spot with 2 or more.

I'm working with a 32", 24" and 20" right now, and wish for 3 40" monitors with how much I tend to have going on.

If buying new for myself, I'd likely go up to 32".

I paid ~$400 for the 32" HP 2560x1440 that I have. It's the sweet spot for my eyesight for size/resolution. I'd really like to pickup a couple of the 40" 4k screens MicroCenter has, but don't have the money to drop on a luxury like that.

Philips has nice 40-43" 4K screens (16:9) for very reasonable money, not for gaming but for office work. We have a couple of them. Two different models, one curved and one flat. I think the curved one has been discontinued. They where like $600 or so.

A monitor that size has roughly the same screen estate as four 1080p HD monitors in the 22-23" range.

Get taht stuff and you start needing a bigger desk

Nah, it's not that bad

Two 27" monitors side by side requires more space but have actually less screen estate.

@Danp said in HDMI Monitor suggestions:

Anyone else using virtual monitors on your 4k setups? I've been using DisplayFusion's Monitor Splitting feature for this.

I only have a single monitor ATM, but this allows me to split it so that it behave like I have more than one.

I used to do that with linux. I think it was called fake xinerama/xrandr. It's standard functionality in X windows.

@travisdh1 said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@travisdh1 said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@scottalanmiller said in HDMI Monitor suggestions:

@pmoncho said in HDMI Monitor suggestions:

@WrCombs said in HDMI Monitor suggestions:

Just finished Moving from Windows 7 Desktop to Windows 10 Laptop as the daily driver at work.
only thing i'm missing is my second screen and that's cause I'm missing the HDMI port on the Monitors we have here.
My Boss is going to buy what ever screen I pick out, with that said, what are your suggestions for a new monitor that is compatible with HDMI? (Which should be any recently made monitor, right? )

If going with a new monitor, I've always been partial to Dell 24" U2419H line. Nice color, crisp, clear.

If going new, I like 27" or larger.

If a single monitor, I agree 27 or larger would be the way to go. I have had 2 or more monitors for so long, it slips my brain that many will probably have one. I have found that 24" monitors hit a sweet spot with 2 or more.

I'm working with a 32", 24" and 20" right now, and wish for 3 40" monitors with how much I tend to have going on.

If buying new for myself, I'd likely go up to 32".

I paid ~$400 for the 32" HP 2560x1440 that I have. It's the sweet spot for my eyesight for size/resolution. I'd really like to pickup a couple of the 40" 4k screens MicroCenter has, but don't have the money to drop on a luxury like that.

Philips has nice 40-43" 4K screens (16:9) for very reasonable money, not for gaming but for office work. We have a couple of them. Two different models, one curved and one flat. I think the curved one has been discontinued. They where like $600 or so.

A monitor that size has roughly the same screen estate as four 1080p HD monitors in the 22-23" range.

@WrCombs said in Data Base Management:

@dave_c said in Data Base Management:

@WrCombs
Now I'm intrigued. Can you do me a favor?
Please download http://www.alexnolan.net/software/dbf.htm and try to open a copy of one of those DBfs.

• If it works you will have your solution
• If it does not work, I will owe you one

So I know it's been a while since we talked about this ; however, this worked.
Just wanted to let @dave_c know it worked..
Big thanks

Yeah, .dbf are dBase files. Simple binary format. One file per table.

Sometimes there are index files and other files as well. It's been around for a long time. It's what you use when you need something simple and don't want the overhead of a real RDBMs like Oracle or SQL Server. Modern equivalent would be SQLite.

I don't know the best solution to @dave247 and his clunkyness problem.

But I'm thinking if you can raise the security on the VPN link with 2FA, you could probably relax screen savers, VPN link timeouts and other things.

Workers that are 100% remote should basically only have to login once per day and establish their RDP session and then just have screen lock on their laptop.

@Dashrender said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

@Dashrender said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

Also are you using split tunneling on the VPN connection or is all traffic passing over VPN when connected?

I'm curious how this plays into the current conversation?

OP said he wanted to "make the best use of the remote session in terms of data transmission". It also plays into the security issue, together with credentials and logins.

aww - definitely understand the bandwidth portion, but not the creds/logins though.

Split tunneling is in general considered less secure because the user's computer is basically bridging the internet and your corporate network. And you have zero or little control over the traffic outside the VPN, unless you have some security in place for this.

When not using multi-factor authentication for the VPN tunnel (which the OP isn't) you are more susceptible to phishing attacks.

With split-tunneling and no 2FA on the VPN it's much easier to trick the users to enter their credentials into something that looks just like real thing.

That's how it ties into the security - overall risk.

Here are some covid-19 recommendations for VPNs.
https://www.us-cert.gov/ncas/alerts/aa20-073a

Microsoft have some new recommendations on how to do split tunneling VPN, particular with O365 and on-prem, to make it secure and to take load and bandwidth off the VPN connection.

Not related to security but it's also possible to have a bandwidth limitation in the VPN appliance without having a bandwidth limitation on the WAN link. There is usually a maximum VPN bandwidth in the firewall / VPN appliance.

@Dashrender said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

Also are you using split tunneling on the VPN connection or is all traffic passing over VPN when connected?

I'm curious how this plays into the current conversation?

OP said he wanted to "make the best use of the remote session in terms of data transmission". It also plays into the security issue, together with credentials and logins.

@dave247 said in Looking for solutions to allow remote users access to their internal psychical computers:

Login 1 : User logs into business issued laptop
Login 2 : User connects to company over SSLVPN using domain credentials
Login 3 : User connects to their internal physical PC via RDP using their domain credentials

Do they use the domain credentials to log in on the laptop as well?

What's the timeout on the laptop / VPN link / desktop (over RDP) that would require them to have to login again?

Also are you using split tunneling on the VPN connection or is all traffic passing over VPN when connected?

@dave247 said in Looking for solutions to allow remote users access to their internal psychical computers:

the user experience is clunky

This is what I'm more interested in. Why is it clunky? (Besides the 1 extra login for VPN...)

I'm on VPN & RDP basically everyday. I think it's pretty smooth.

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

@scottalanmiller said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

OK, maybe semantics but I wouldn't say you log into VPN. More like connect.

Most VPNs use a login. It's the same mechanism as the RPD login. You can say connect as well, but only in the sense that connect is another way to say login. You "connect" to RPD as well, in the same sense.

You connect with RDP but the login you enter is for the computer - the only place you actually log into. IMHO.

But makes no difference however.

VPN might be an additional step unless you have site-to-site connection. However you don't have to commute, enter a parking garage, security code to building etc etc. So that should make it an even playing field between the hassles of getting to work physically versus connect with VPN.

@scottalanmiller said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

OK, maybe semantics but I wouldn't say you log into VPN. More like connect.

Most VPNs use a login. It's the same mechanism as the RPD login. You can say connect as well, but only in the sense that connect is another way to say login. You "connect" to RPD as well, in the same sense.

You connect with RDP but the login you enter is for the computer - the only place you actually log into. IMHO.

@Dashrender said in Looking for solutions to allow remote users access to their internal psychical computers:

@Pete-S said in Looking for solutions to allow remote users access to their internal psychical computers:

I don't understand how the use of RDP could do anything to cause multiple logins?

If you RDP in to your desktop using the same login as usual then everything is exactly the same as if you're physically there.

You log into VPN, then you log into RDP - I assumed that was the multiple logons he was talking about... beyond that, if there are additional ones that don't already exist when users are working onsite, then it seems like something would be wrong.

The idea to get away from two logons (VPN and RDP) seem like a lot of effort.

OK, maybe semantics but I wouldn't say you log into VPN. More like connect.

Most companies I know have 2FA (for VPN) and the user enters a pin code into that. But I guess that's a password too in a way.

I don't understand how the use of RDP could do anything to cause multiple logins?

If you RDP in to your desktop using the same login as usual then everything is exactly the same as if you're physically there.

Update to 19.10. Has been stable and good for us. Also 19.04 was trouble free.

Had a look at nodeweaver's website - https://www.nodeweaver.eu

It looks interesting. They have a clear edge computing, IoT, Industry 4.0 focus on their product and their customers. So it's not a generic IT HCI product but rather geared towards those types of applications.

So what's the difference really? Well, the difference is that it's probably going to be managed by technicians and not IT. So it's design is likely geared towards easy of use and stability rather than towards bleeding edge features and lots of settings.

And also possibly tuned to run on very modest hardware as that is common feature of edge devices. It's also very likely that it is tuned for deterministic real time applications, which is common on edge devices and IIoT. KVM has PREEMPT-RT which are patches to give better performance for real time applications. Basically you want to know that an application will respond within a certain time, every time, regardless of what it is doing.

So this could be a good thing or a bad thing. Most things like real time patches improves things where it is needed but doesn't cause much performance loss where it is not needed. Anyway, as a product I think if you want a turn-key system it will probably be a good fit. If you want to be able to tinker with everything it will probably not be the right choice.

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

And when you use -e you should have it after user and password so the SQL commands you want to execute comes after the -e.

That was a once off artifact of me doing it on this system after the root password has been set.

OK, so maybe this then:

sudo mysql -e "CREATE USER [email protected] IDENTIFIED by '$DB_PASS';"
sudo mysql -e "GRANT ALL ON $DB_NAME.* TO [email protected];"
sudo mysql -e "FLUSH PRIVILEGES;"

right. Updating the guide. but half tempted to leave the single quotes everywhere it that causes no error in order to protect against spaces by others. Though I am using pwgen to to this.

It's kind of f*cked up to have spaces in user names and passwords. Personally I don't use something unless it's specifically needed but either way works.

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

And when you use -e you should have it after user and password so the SQL commands you want to execute comes after the -e.

That was a once off artifact of me doing it on this system after the root password has been set.

OK, so maybe this then:

sudo mysql -e "CREATE USER [email protected] IDENTIFIED by '$DB_PASS';"
sudo mysql -e "GRANT ALL ON $DB_NAME.* TO [email protected];"
sudo mysql -e "FLUSH PRIVILEGES;"

Alright, after some troubleshooting. The line on your script should be:

sudo mysql -e "GRANT ALL ON $DB_NAME.* TO '$DB_USER'@'localhost';"

No ' around $DB_NAME. That gives you a syntax error.

Also since DB_USER doesn't contain spaces and neither does localhost, you don't need any ' around those either (but it doesn't cause any syntax errors).

And when you use -e you should have it after user and password so the SQL commands you want to execute comes after the -e.

sudo mysql -uroot -p$DB_ROOT_PASS -e "CREATE USER [email protected] IDENTIFIED by '$DB_PASS';"
sudo mysql -uroot -p$DB_ROOT_PASS -e "GRANT ALL ON $DB_NAME.* TO [email protected];"
sudo mysql -uroot -p$DB_ROOT_PASS -e "FLUSH PRIVILEGES;"

I'm sure you know but you can also put more than one command in the execute string. ; is what separates the commands.
Or put the SQL in a file.
For instance:

sudo mysql -uroot -p$DB_ROOT_PASS -e "GRANT ALL ON $DB_NAME.* TO [email protected]; FLUSH PRIVILEGES;"

@JaredBusch said in WP-CLI and database users:

@Pete-S well WTF... Even after the DB exists..

The DB_NAME is correct.....

I don't understand why. What happens if you just login and do it manually? Do you get the same result?

"Unknown database". To me that is related to the default database set in mysql sessions. Do you have a USE command somewhere?

Best action might be to test all the SQL commands manually instead of from the script.

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

@JaredBusch said in WP-CLI and database users:

ok a better example of my issue with WP-CLI and the database....

in my new guide to standing up WP I have this step.

I think this is a horrible solution. In order to let wp-cli create the dataabse, the WP DB user have to have the ability to actually CREATE a database.

So unlike more normal guides where I tell you to create a DB user with GRANT ALL only on the database it needs (dbname.*), I had to create it with GRANT ALL on everything (*.*).

I guess, I could refrain from setting the root password stuff until the very end and first revoke these permission and then re-add with only GRANT ALL on the specific database.

But that just seems stupidly clunky.

I think you are mistaken. Just grant the privileges to the database you are about to create

 sudo mysql -e "GRANT ALL ON '$DB_NAME'.* TO '$DB_USER'@'localhost';"

then you can do the wp-cli stuff like wp config create, wp db create etc.

My results on a google search were unclear. So I went assuming no as that is illogical to me.

But wouldn't be the first time something illogical to me was fact.

Well, it's very logical to me. And I just confirmed on MariaDB 10.1.44 that it works the way I thought it did.

Privileges are dependent on object names and not a particular object. Therefor the rights to something on a database, table or whatever can be created before that something exists.

Well that works for me. I'll update the guide in a bit and then run through a new deployment as a test.

Great. I like the guides you post, they are very well thought out.

@JaredBusch said in WP-CLI and database users:

@Pete-S said in WP-CLI and database users:

@JaredBusch said in WP-CLI and database users:

ok a better example of my issue with WP-CLI and the database....

in my new guide to standing up WP I have this step.

I think this is a horrible solution. In order to let wp-cli create the dataabse, the WP DB user have to have the ability to actually CREATE a database.

So unlike more normal guides where I tell you to create a DB user with GRANT ALL only on the database it needs (dbname.*), I had to create it with GRANT ALL on everything (*.*).

I guess, I could refrain from setting the root password stuff until the very end and first revoke these permission and then re-add with only GRANT ALL on the specific database.

But that just seems stupidly clunky.

I think you are mistaken. Just grant the privileges to the database you are about to create

 sudo mysql -e "GRANT ALL ON '$DB_NAME'.* TO '$DB_USER'@'localhost';"

then you can do the wp-cli stuff like wp config create, wp db create etc.

My results on a google search were unclear. So I went assuming no as that is illogical to me.

But wouldn't be the first time something illogical to me was fact.

Well, it's very logical to me. And I just confirmed on MariaDB 10.1.44 that it works the way I thought it did.

Privileges are dependent on object names and not a particular object. Therefor the rights to something on a database, table or whatever can be created before that something exists.

Or in this case, give the right to a user to create a database before that database exists.

@hobbit666 said in What Are You Doing Right Now:

Home lab cleanup. Going to see if I can get the front off to clean the vents, but looks like I need to pull everything out.

Also going to consider installing a new hypervisor, KVM, XCP-NG, etc etc

What did you do to that poor machine???

Don't know if you have access to it but the best way to get remove dust is to blow it out with compressed air, preferably from an air compressor. Otherwise it's very difficult to get the dust that is inside things like power supplies.

@JaredBusch said in WP-CLI and database users:

ok a better example of my issue with WP-CLI and the database....

in my new guide to standing up WP I have this step.

I think this is a horrible solution. In order to let wp-cli create the dataabse, the WP DB user have to have the ability to actually CREATE a database.

So unlike more normal guides where I tell you to create a DB user with GRANT ALL only on the database it needs (dbname.*), I had to create it with GRANT ALL on everything (*.*).

I guess, I could refrain from setting the root password stuff until the very end and first revoke these permission and then re-add with only GRANT ALL on the specific database.

But that just seems stupidly clunky.

I think you are mistaken. Just grant the privileges to the database you are about to create

 sudo mysql -e "GRANT ALL ON '$DB_NAME'.* TO '$DB_USER'@'localhost';"

then you can do the wp-cli stuff like wp config create, wp db create etc.

@scottalanmiller said in What Are You Watching Now:

@Pete-S said in What Are You Watching Now:

Just watched Bad Boys for Life. Good fun!

On Netflix yet?

Don't think so, not yet at least. Netflix is mostly older movie releases or their own limited production.
New stuff you have to buy from Amazon Prime, iTunes and such. Or find it in some dark corner of the web.

Usually it first the cinema release, then after close to six months the VOD & Bluray release and then when most of those sales are done it will be available on things like netflix and cable. Coronavirus have made the movie execs move up the VOD release dates though and postpone cinema release dates.

Just watched Bad Boys for Life. Good fun!
Better than I thought it would be.