Blogs

Stay ahead with the latest trends in custom software development. Explore how AI, automation, and cloud solutions are shaping the future of business technology.

Data from a Pivot

see the example below: [vb] Sub PTTest() Dim SH As Worksheet ‘ the current worksheet from the colection of workbooks Dim PT As PivotTable ‘ the current pivot table from the current worksheet Dim PTC As Range ‘ the cell range of the current pivot table Dim Tmp AsString’ the buffer for concatenated cell values […]
Continue Reading

Reset MYSQL root password – Linux

Reset MYSQL root password – Linux Log on to your Linux machine as the root user. The steps involved in resetting the MySQL root password are to stop the MySQL server, restart it without the permissions active so you can log into MySQL as root without a password, set a new password, and then restart […]
Continue Reading

UNIX Boot Mode – Run Levels

UNIX Boot Mode – Run Levels Runlevel “3” will boot to text or console mode and “5” will boot to the graphical login mode ( “4” for slackware) Runlevel Scripts Directory (Red Hat/Fedora Core) State 0 /etc/rc.d/rc0.d/ shutdown/halt system 1 /etc/rc.d/rc1.d/ Single user mode 2 /etc/rc.d/rc2.d/ Multiuser with no network services exported 3 /etc/rc.d/rc3.d/ Default […]
Continue Reading