2.10.4 Securing the Initial MySQL Account

Here is the article. 

The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. For details, see Section 2.10.1, “Initializing the Data Directory”.

This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if you have not already done so.

A password may already be assigned to the initial account under these circumstances:

• On Windows, installations performed using MySQL Installer give you the option of assigning a password.

• Installation using the macOS installer generates an initial random password, which the installer displays to the user in a dialog box.

• Installation using RPM packages generates an initial random password, which is written to the server error log.

• Installations using Debian packages give you the option of assigning a password.

• For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it expired, and writes it to the server error log. See Section 2.10.1, “Initializing the Data Directory”.

The mysql.user grant table defines the initial MySQL user account and its access privileges. Installation of MySQL creates only a 'root'@'localhost' superuser account that has all privileges and can do anything. If the root account has an empty password, your MySQL installation is unprotected: Anyone can connect to the MySQL server as root without a password and be granted all privileges.

起亚第五代Sportage狮铂拓界，三款动力选择预售17.98万元起

Original 赵永健 达车汇 2022-09-28 17:13 Posted on 北京

Here is the article. 

9月28日，起亚第五代Sportage狮铂拓界正式开启预售，其中1.5T+8AT车型预售价17.98万元起、2.0T+8AT车型预售价19.08万元起、2.0L HEV+6AT车型预售价20.58万元起。新车出自第三代i-GMP平台，是同级合资SUV中为数不多的标配8AT变速器的车型，预计将于11月份正式上市。

此外，起亚还为用户准备了预售六重好礼，包含拓界·翻倍礼、拓界·露营礼、拓界·保养礼、拓界·安心礼、拓界·回馈礼和拓界·观赛礼，可谓诚意拉满。权益包括10年10次免费基础保养、混动版车型享三电10年或20万公里质保，预售订单前5,000名客户，赠价值6666元的起亚与知名品牌联名露营套装1套等。

提供三款动力选择

在第五代Sportage狮铂拓界身上，起亚也使出了洪荒之力了，尤其是在动力上，标配8AT变速器，是同级合资SUV中为数不多的标配8AT的车型。狮铂拓界提供了三种高性能黄金动力组合，分别为1.5T+8AT、2.0T+8AT和2.0L HEV+6AT。

其中1.5T发动机最大马力200Ps，最大扭矩253N·m，并采用了起亚全球独创的第四代CVVD技术，配合8AT变速箱，零百公里加速时间仅8.7S，WLTC综合油耗低至7L。

2.0T发动机最大马力234Ps，最大扭矩353N·m，零百加速时间仅为7.8S，是同级竞品中唯一提供2.0T+8AT黄金动力组合的车型，追求良好加速性的用户可以考虑选择2.0T车型。

另外，狮铂拓界还引入混动车型，2.0L HEV车型的混合动力系统采用的是TMED混合动力系统，该系统由发动机、变速箱、超薄高功率永磁同步电机、锂离子电池、HSG启动发电一体机、HPCU一体式控制器等构成。系统综合功率为200Ps，综合扭矩为350N·m，WLTC综合油耗低至5.6L。

出自第三代i-GMP平台的狮铂拓界还提升了车辆的整体操控感，提高方向盘转向速比，整体调教优化，确保可靠的制动力，带来优异的制动距离。2.0T可选配电子适时四驱系统，AWD ECU判断路面情况及车辆驾驶状态，精密控制AWD连接器多板离合器的紧固力，主动改变分配到前后轮的驱动力，提供稳定的转弯和良好的行驶性能，确保驾驶员轻松应对不同艰难路况。

历经五代进化的高颜值

作为起亚在全球最畅销的车型之一，Sportage近30年历经5次换代、累计销量超过660万辆。1993年，第一代Sportage应运而生，作为一款城市型SUV，全面满足了用户旅行、日常出行等多场景出行需求。而在国内市场，起亚第二代Sportage以“狮跑”命名并于2007年引入国内，后续换代以智跑、KX5等车型，并采用多代同堂的方式销售。而到了第五代起亚Sportage选择全球同步，以英文音译的方式命名为狮铂拓界。

狮铂拓界是起亚“Opposites United(对立统一)”全新理念下的首款国产车型，高颜值是它的亮点之一，在路上一眼就识别出它的身份。经过重新演绎的“虎啸式”进气格栅与回旋镖式LED日间行车灯融为一体，平滑的车窗线条延伸到尾部微微上扬，强化了侧面运动气息。此外，新车还提供了丛林绿、哑光灰、星钻蓝、星际灰、珍珠白以及极光黑六种外观颜色。

针对中国消费者的审美需求，狮铂拓界对内饰进行了优化升级，提供有双12.3英寸沉浸式一体曲面屏、SBW旋钮式电子换挡系统、隐藏式空调出风口等设计，这些都不输于同级竞品，看起来很有科技感。同时，新车提供深灰、黑红、蓝灰、黑色四种内饰配色，让用户自主选择喜欢的配色。

在空间方面，狮铂拓界长宽高4670/1865/1680mm，轴距达到2755mm。针对中国消费者对于舒适性的高要求，狮铂拓界除了提供有前排座椅6向电动调节和通风&加热功能外，还提供了一般高端豪华车型才有的后排座椅加热功能，并且采用了高级绗缝工艺真皮座椅，包裹感和舒适性更佳。

在NVH方面，狮铂拓界在车身多处采用了高水准隔音材料，前挡风玻璃和前排车窗均采用双层隔音玻璃，可以有效阻隔外界噪音进入车内。此外，狮铂拓界还搭载智能感应电动尾门、前排手机无线充电等便利性配置。

智能化领先同级竞品

要打动年轻用户，智能化装备是少不了的，起亚从K5开始在智能化方面就领先同级竞品，尤其是在智能车机方面。这次狮铂拓界搭载了全新升级的Kia Connect智能互联系统，内置双区语音识别、百度导航、CarLife功能、声音存储功能。

此外，狮铂拓界还设计了代客模式，当车主开启代客模式后，信息娱乐系统界面将实现锁屏，避免个人隐私的泄露。同时，还有IoT车家互联系统，可与家用物联网进行连接，在车内就可以控制家中的智能设备。而停车场自动结算也很实用，登录车辆信息及支付信息后，可在ETCP加盟停车场自动支付停车费。

另外，当后排乘客有小憩的需求时，开启后排安静模式，后排扬声器将不再发出声音，而前排扬声器的声音也会相应变小，打造前后排空间互不干扰的乘坐体验。

在智能辅助驾驶方面，狮铂拓界配置L2＋级智能驾驶辅助系统，标配10项智能驾驶辅助功能，包括前方防撞辅助（FCA）、车道跟随辅助（LFA）、车道保持辅助（LKA）、智能限速辅助（ISLA）、智能远近光调节（HBA）、驾驶员疲劳提醒（DAW）等。此外，狮铂拓界特别搭载了可以有效降低二次碰撞事故发生概率的MCB多次碰撞自动制动系统，进一步刷新了安全标准。

总的来说，作为起亚在全球最畅销的车型之一的第五代Sportage，这次拿出了诚意给到中国消费者。相信随着11月的上市，将助力起亚在国内市场开启新一波攻势。

Open road | Kia sportage | Rhichmond | Feb. 4, 2023

 Here is the link.

Michael Hartnett is So Bearish, He's Bullish | Stock Talk Podcast

Here is the link. 

Michael Hartnett is the Chief Investment Strategist at Merrill Lynch. Amongst all of Merrill's economists and strategists, he is perhaps the most well followed by institutional and retail investors. It's a big title, and he's followed by 100's of thousands of advisors and millions of investors. He's been around the block for a few decades and seen a few economic and stock cycles. 00:00 Introduction 02:30 Bullish Signs 05:40 Market Breadth 08:20 Technology Stocks 11:15 Contact Us! He predominately uses a data-driven approach. While too conservative in his second-half 2021 outlook, he was one of the first sell-side strategists to correctly call for a first-half 2022 sell-off for what turned out to be the right reason. That reason. Higher inflation and slowing growth. This is also known as "stagflation" in economic circles. Late Monday night last week. Early Tuesday morning, July nineteenth, he released his much-anticipated Global Fund Managers Survey. Its title, in bold headlines, read, "I'm so Bearish. I'm Bullish." Here are the links to the previous videos on Opportunity Knocks: https://www.youtube.com/watch?v=8T_Fy... https://www.youtube.com/watch?v=2Hq0S... Here’s a link to Jim Cramer’s July 19th episode reviewing Larry Williams charts. We’ve discussed Mr. William's work in prior videos. https://www.cnbc.com/2022/07/19/chart... #InvestmentPlanning #RetirementPlanning #OakHarvestFinancialGroup At Oak Harvest, we think our clients are best served by us helping them with their future needs and risks, instead of dwelling on the past. Our forecasting is far from perfect, but we like to keep you up on what it's saying about the uncertain future, not rehashing an already certain past. Stock Talk is a weekly podcast dedicated to discussing the Investment Team's perspective on what's happening in the market. Hosted by Chief Investment Officer Chris Perras, each episode brings you our views on stocks, the market, and the economy — with a little Education thrown in for good measure. Listen each week and help stay connected to your money! Also available on Spotify, Google Play and Podbean. Do you need a retirement plan that goes beyond allocating funds to truly fit your needs? We can help you create a retirement life plan customized for your retirement vision and legacy. Call us at (877) 404-0177 or fill out this form for a free consultation: https://click2retire.com/michaelhartn... About Chris Perras, CFA®, CLU®, ChFC®, Chief Investment Officer As CIO, Chris is lead investment strategist and director of research at Oak Harvest Financial Group. Chris develops the firm's core market outlook, putting his decades of experience and expertise to work for our clients. He hosts Oak Harvest's podcast, "Stock Talk," available on the website with new episodes each week. Chris completed his undergraduate studies at Georgia Tech, and went on to obtain an MBA from the Harvard Business School. Driven by a desire to maximize his knowledge and skill set, Chris acquired a plethora of financial planning and investment management qualifications, becoming a Chartered Life Underwriter (CLU®), a Chartered Financial Consultant (ChFC®), and a Chartered Financial Analyst (CFA®).

Andrew Ross Sorkin

 Andrew Ross Sorkin (born February 19, 1977) is an American journalist and author. He is a financial columnist for The New York Times and a co-anchor of CNBC's Squawk Box. He is also the founder and editor of DealBook, a financial news service published by The New York Times. He wrote the bestselling book Too Big to Fail and co-produced a movie adaptation of the book for HBO Films. He is also a co-creator of the Showtime series Billions.^[1]

Dentist claim | January 2023

 

A Driver’s Prayer - Powerful prayer for traveling and driving

Here is the link. 

Dear God

Our Heavenly Father Give me firm hands, attentive eyes, prudence and perfect control So that I may make a good journey and arrive happily at my destination Together with me protect my passengers Teach me to respect the signs to use my car for good purposes and teach me to remain vigilant on the drive ahead Please grant me the presence of mind to stay alert and watchful Keep my vision clear and help me see the risk so I may respond to them Lord I go with you I am safe with you I do not travel alone For your hand is upon me Your protection is divine Keep me safely protected in your sheltering arms Always knowing that you are with me In the name of our Lord Jesus Christ I pray Amen

MySQL workbench | Day one

I like to learn more about MySQL workbench. 

Open MySQL workbench | Administrator 

Navigator -> Administration | Schemas 

Management

• Server status
• Client connections
• Users and privileges
• Status and system variables
• Data export
• Data import/ Restore

Instance

• Startup / Shutdown
• Server logs
• Options File

Performance

• Dashboard
• Performance Reports
• Performance Schema Setup 

Schemas 

• mywordpress
• Sakila
• sys
• world

Canada Towing LTD | 604-715-1717

Brake & muffler | 604-438-1553 Kingsway, Vancouver

AK Auto works

Here is the link. 

I like to learn more about this auto place. 

2022 KIA SPORTAGE SAFETY RATINGS

 Sure, the Kia Sportage is among our most stylish models. A fresh exterior, numerous driver-assist technologies, and available All-Wheel Drive make it competitive in its class. What about the 2022 Kia Sportage safety ratings, though?

Easton, Allentown, and Quakertown, PA, shoppers can expect stratospheric safety ratings from the Sportage—and that’s no hyperbole. See how this Kia SUV earned some of the best ratings in the game with our experts at Brown-Daub Kia!

KIA SPORTAGE NHTSA SAFETY RATING

The National Highway Traffic Safety Administration (NHTSA) performs crash tests annually on a variety of models. Three parts comprise their crash-testing process: frontal crash, side crash, and rollover tests.

Individual scores are then compiled into an overall safety score for the model in question. For 2022, the Kia Sportage earned a 5-Star Overall Safety Rating from the NHTSA. Here’s how it fared in the individual tests:

• Frontal Crash: 4 Stars
• Side Crash: 5 Stars
• Rollover: 4 Stars

With a perfect score on the side crash test, the Sportage is engineered to help keep you safe in some of the most common accidents.

KIA SPORTAGE IIHS SAFETY RATING

Another organization that carries out crash testing is the Insurance Institute for Highway Safety (IIHS). They put models through six “crashworthiness” tests, as well as crash avoidance and mitigation testing, finishing with a look at child seat anchors.

Although 2022 data is not yet available, the 2021 Kia Sportage fared extremely well on testing, emerging as a 2021 TOP SAFETY PICK for the IIHS. With a perfect score of “Good” in all six crashworthiness tests, the honor was hardly unexpected! The six tests included:

• Small overlap front: driver-side (Good)
• Small overlap front: passenger-side (Good)
• Moderate overlap front (Good)
• Side (Good)
• Roof strength (Good)
• Head restraints & seats (Good)

Meanwhile, available LED projector headlights (found on the SX Turbo trim level) earned an “Acceptable” rating from the IIHS. Although they are not curve adaptive, they do feature High Beam Assist to help you see farther up the road.

DRIVE SMART WITH KIA DRIVE WISE

Engineered to help keep you safe in the event of an accident, the Kia Sportage has another ace up its sleeve. It’s one we haven’t yet discussed: accident prevention.

Obviously, it’s better to prevent a collision than simply mitigate it, and Kia Drive Wise helps make that possible. This driver-assist suite comes standard—but it has even more features available for higher trim levels.

It relies on a system of sensors and cameras to help keep you safe in the Sportage. Standard and available features include:

• Forward Collision Avoidance Assist w/ Pedestrian Detection 
• Lane Keeping Assist and Lane Departure Warning
• Driver Attention Warning 
• Rear Cross-Traffic Collision Warning
• Blind-Spot Collision Warning

SUVs | Vancouver area | Canada

 

Best SUVs in Canada for 2022

Your buying guide to the best SUV in 2022

Over the last decade, SUVs in Canada have risen in popularity for many drivers.

Buying a new vehicle can be overwhelming. Today’s brands are fuel-efficient, include top safety features, and can easily have additional car modifications to suit your driving lifestyle.

In 2019, SUVs and pickups account for 70 percent of the market. The last time cars outsold SUVs and trucks were 10 years prior in 2009.

Manufacturers are picking up on this trend, which means there is an abundance of new models to choose from. We researched the top make and models across Canada to simplify your buying process.

What does SUV stand for?

SUV stands for a sports utility vehicle. They are designed to have a higher seating position and sit higher up compared to cards. The majority have all-wheel drive and additional space for storage and passengers. They are better for fuel economy compared to trucks and many have off-road capability.

As the automotive industry has evolved, makers have included SUVs and crossovers – the term is interchangeable, but some crossovers are lower to the ground.

Are SUVs safer than sedans?

It’s not just the added cargo room - one of the most common reasons why people choose SUVs is that they are taller and heavier than sedans, making passengers and drivers feel safer. Some models have inflatable rear seatbelts, adaptive cruise control, and blind spot detection.

3 Advantages to SUVs

There and many benefits to SUVs whether you are seeking utility or luxury, without compromising safety. Here is an overview of the top three advantages to SUVs :

• More space : Whether you are an avid camper or have a family who partakes in sports, the added space of SUVs allows for extra passengers and cargo when necessary.
• Enhanced visibility :The height of being behind the wheel of an SUV gives drivers a better view of the road ahead. The higher driving position allows for seeing more of the road, which can help you avoid obstructions and traffic.
• Improved capability : Most models have an all-wheel drive which can be beneficial during severe weather and hazardous conditions.

• How to decide which SUV to buy

• Some midsized models include a third-row seat for extra passenger space. You’ll also want to research the added vehicle safety features, technology, 2WD vs AWD vs 4WD, and towing capacity. Calculating the average kilometers you drive will help you understand how much money you may be spending on fuel.

  When you are deciding which model to buy, consider the different sport utility vehicle classes :

  • Mini : The smallest type you can get – they generally look like a smaller crossover vehicle and costs begin around $20,000.
  • Compact : Also known as subcompact, they often have an elevated height, upright seating, and are easy to maneuver. You’ll spend on average $20,000 to $35,000.
  • Mid-size : Mid-size models provide power, space, safety and are common among families with kids. The average price is between $30,000 to over $50,000. Luxury models generally surpass $60,000.
  • Full-size : Large, full-size SUVs have plenty of power, interior space and towing capacity. They are best suited to a driver who needs to haul a trailer or a big family. They usually have a higher price tag of upwards of $85,000.

  SUVs under $50,000

  A good SUV does not have to break the bank in 2022. Some of the most efficient and tasteful brands can be purchased at an affordable cost. Here are the top SUVs with a base price under $50,000 in Canada.

  • Hyundai Kona : $22,099
  • Subaru Crosstrek : $23,645
  • Kia Sportage : $25,000
  • Subaru Forester : $25,395
  • Mazda CX-30 : $23,000
  • Volkswagen Tiguan : $33,395
  • Toyota RAV4 LE : $28,850
  • Ford Bronco : $30,800
  • Mitsubishi Outlander ES : $31,998
  • KIA Telluride : $33,090
  • Volvo XC40 : $39,950
  • Genesis GV70 : $41,500

  • Top selling compact SUVs in Canada

  • Subcompacts are ideal for families of four, have better ground clearance compared to cars, and you won’t get stuck in the snow on the way to hockey practice. They also have a minimal impact on car insurance.

    If you’re looking for a subcompact sports utility vehicle, here are the top makes and models for you.

    • Toyota RAV4
    • Subaru Forester
    • Ford Escape
    • Ford Bronco
    • Jeep Cherokee
    • Honda CR-V
    • Nissan Rogue
    • Mitsubishi Outlander
    • Mazda CX-5
    • Volkswagen Tiguan

    Source: JD Power

  • Best 2022 midsize SUVs in Canada

    Midsized SUVs in Canada are gaining in popularity because they offer versatility and utility of a modern vehicle due to their seating capacity, the potential for towing, fuel economy, and stronger power compared to compact types. Here are the top midsize SUVs in Canada.

    • Genesis GV70
    • Subaru Crosstrek
    • Hyundai Santa Fe
    • Kia Sorento
    • Toyota 4Runner
    • Toyota Venza
    • Volkswagen Atlas Cross Sport
    • Nissan Murano
    • Honda Passport
    • Jeep Grand Cherokee
    • Chevrolet Blazer

    Source: JD Power

  • Best selling full-size SUVs in Canada

  • If you’re looking to go big, a full-size sports utility vehicle is the best option. People buy them for the higher ground clearance, more passenger capacity, towing, and versatility in terrain. Here are the best large SUVs in Canada.

    • GMC Yukon / Yukon XL
    • Toyota Sequoia
    • Ford Expedition
    • Chevrolet Tahoe
    • Chevrolet Suburban
    • Nissan Armada

    Source: JD Power

  • Best luxury SUVs Canada

  • Drivers who are seeking a bit of luxury in their sports utility vehicles will enjoy these functional yet stylish options.

    • MINI Countryman : A cheerful exterior design with a wide variety of drivetrain options include a plug-in hybrid that when fully charged can run for 30-minutes on pure electricity. Starting at $33,490.
    • Acura RDX : Prepare to take the unconventional road with the 2022 Acura RDX. Starting at $45,800 you’ll enjoy a standard turbocharged engine, 10-speed automatic transmission, panoramic sunroof, and featured accessories.
    • BMW X3 : Designed with the largest cargo space in its class, the X3 drives like a sports sedan but with the countless benefits of an SUV. The 2022 model boasts more comfort and intuitive operation. This luxury SUV starts at $52,990.
    • Audi Q7 : This luxury model knows no limits with it’s excellent driver’s assistance, four-wheel steering, and a ‘virtual cockpit’ you didn’t know you needed. Expect high-resolution screens, three display models, and Google Earth access.

    Source: Canada Drives

Running ALTER TABLE on production MySql with millions of records…

Here is the article. 

Alphabet | mass layoffs

 Business Insider

A major Alphabet investor said the company should cut even more jobs and address 'excessive' pay in the wake of mass layoffs

Beatrice Nolan

January 25, 2023·2 min read

• Alphabet investor TCI is urging the company to "go further" in cutting jobs and reducing spend.

• A letter from TCI to CEO Sundar Pichai said "excessive employee compensation" should be addressed.

• Google's parent company announced on Friday that it was cutting around 12,000 roles.

A major Alphabet investor urged Google's parent to cut more jobs and reduce staff pay on the same day it announced it would lay off around 12,000 staff.

The Children's Investment Fund Management wrote a letter to Alphabet and Google CEO Sundar Pichai on January 20 — the day Google announced mass layoffs affecting roughly 6% of its workforce — asking him to address "excessive employee compensation."

The letter was signed by Christopher Hohn, the fund's founder, portfolio manager, and managing partner. Hohn called the decision to cut jobs a "step in the right direction," but said management still needed to "go further" to reduce headcount.

Hohn, who has a net worth of $7.49 billion, according to Bloomberg's billionaires index, recommended the company cut its workforce to around 150,000 employees, which he said would require a headcount reduction of around 20%. At the end of the third quarter of 2022, Alphabet employed 186,779 people.

The letter asked Alphabet's management to "take the opportunity to address excessive employee compensation."

"The median salary at Alphabet in 2021 amounted to nearly $300,000, and the average salary is much higher," Hohn's letter continued.

"Competition for talent in the technology industry has fallen significantly allowing Alphabet to materially reduce compensation per employee."

The London-based hedge fund has been a significant shareholder in Alphabet since 2017, it said in a separate letter, which was dated November 15 and also addressed to Pichai.

The November letter, also signed by Hohn, said its shares in the company were worth more than $6 billion. It included similar comments to the January letter, and said Alphabet had too many employees.

Representatives for Alphabet and TCI Fund Management did not respond to Insider's request for comment.

Read the original article on Business Insider