Cara menggunakan mysql server automatically start

Cara menggunakan mysql server automatically start
Download Article

Download Article

If you want your XAMPP modules (e.g., Apache, PHP, and MySQL) to launch automatically with Windows, you'll need to add the XAMPP Control Panel to your Startup folder. This wikiHow teaches you how to make the XAMPP Control Panel start automatically when you boot Windows, and how to select which XAMPP modules open automatically. You can use this method in Windows 10, 8.1, 8, and 7.

Steps

  1. Cara menggunakan mysql server automatically start

    1

    Open the XAMPP Control Panel. It's in the root of the folder in which you installed XAMPP, which is usually C:\xampp. The file itself is called xampp-control.exe. If you didn't change the installation directory, follow these steps to launch the app:

    • Press Win+R to open the Run dialog.
    • Type or paste C:\xampp\xampp-control.exe into the field.
    • Click OK.

  2. Cara menggunakan mysql server automatically start

    2

    Click Config. It's the button with a wrench at the top-right corner of the XAMPP Control Panel.[1]

    Advertisement

  3. Cara menggunakan mysql server automatically start

    3

    Select items to launch at startup. Click the box next to any of the modules in the "Autostart of modules" area to select it for automatic startup. If a box contains a checkmark, it means the module will start when you launch the XAMPP Control Panel.

  4. Cara menggunakan mysql server automatically start

    4

    Click Save. It's the button with a green checkmark at the bottom-right corner of the window.

  5. Cara menggunakan mysql server automatically start

    5

    Open the Windows File Explorer. One way to do this is to right-click the Start menu and select File Explorer. You could also press Win+E to launch it with the keyboard.

  6. Cara menggunakan mysql server automatically start

    6

    Navigate to your xampp directory. The location is typically C:\xampp, and you can usually get there by expanding the This PC or Computer menu in the left panel, selecting the C: drive, and then clicking xampp. The contents of the directory will appear in the main panel.

  7. Cara menggunakan mysql server automatically start

    7

    Right-click xampp-control.exe and select Create Shortcut. A new file will appear just below called xampp-control.exe – Shortcut.

    • Just leave this window open for now, as you'll need it in a few moments.

  8. Cara menggunakan mysql server automatically start

    8

    Press Win+R. This opens the Run dialog.

  9. Cara menggunakan mysql server automatically start

    9

    Type shell:startup and click OK. This opens the Windows Startup folder in a new File Explorer window.[2]

  10. Cara menggunakan mysql server automatically start

    10

    Drag xampp-control.exe – Shortcut to the Windows Startup folder. Once you've added the shortcut to the Startup folder, Windows will know to open the XAMPP Control when the PC boots. The modules you selected to run automatically will activate as soon as the XAMPP Control Panel starts.

    • If you can't see both windows on the screen at once, you can right-click the taskbar (the bar that usually runs along the bottom of the screen) and select Show windows side by side.

  11. Advertisement

Add New Question

  • Question

    I stopped Apache and MySQL in Aampp and shut down my PC, then the problem that arises is that when I start my PC again, I cannot find my Xampp server. Where to find it?

    Cara menggunakan mysql server automatically start

    Dharashah

    Community Answer

    Xampp server can be found in the Xampp folder where you have installed it. Start the xampp-control.exe and this will let you start the Apache and MySQL servers.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Thanks for submitting a tip for review!

About This Article

Article SummaryX

1. Open the XAMPP Control Panel.
2. Click Config.
3. Select modules and click Save.
4. Open File Explorer to C:\xampp.
5. Right-click xampp-control.exe and select Create Shortcut.
6. Press Windows Key + R.
7. Type shell:startup and click OK.
8. Drag the shortcut from C:\xampp to the Startup folder.

Did this summary help you?

Thanks to all authors for creating a page that has been read 238,543 times.

Is this article up to date?

Bagaimana cara memulai service MySQL?

Klik menu Start > Control Panel > System and Security > Administrative Tools dan dari jendela yang terbuka, klik ganda Services. Untuk mulai menjalankan servis Windows dari MySQL, klik kanan pada MySQL dan pilih Start pada menu pop-up yang muncul.

Bagaimana cara menjalankan MySQL dari command prompt?

Caranya, ketik “cd C:\MySQL 8.0\bin” pada command prompt lalu tekan Enter. Perintah diatas akan menjalankan mysqld dengan tambahan baris perintah –defaults-file=”C:\MySQL 8.0\Data\my.ini”.

Cara yang dapat gunakan untuk menguji apakah MySQL server sudah berjalan?

Untuk memastikan bahwa MySQL Server telah berjalan dan siap digunakan, Anda dapat mencoba menuliskan perintah (command) "select –version();" di baris perintah (prompt) MySQL (mysql>) dan kemudian tekan tombol keyboard Enter untuk mengetahui versi MySQL Server yang terinstal.

Bagaimana cara membuat database di MySQL?

Untuk membuat database MySQL baru, masuk cPanel dan klik menu MySQL Databases:.
Pilih nama database. Prefix defaultnya adalah "yoururser_". ... .
Scroll ke bawah dan cari Add New User. Masukkan username dan password, lalu klik Create User:.
Cari opsi Add User To Database untuk menghubungkan User ke Database. ... .
Selesai!.