This document provides information about MySQL databases.  Topics include creating databases, removing databases, adding users to a database, changing database passwords, and setting up your database with scripts.  The control panel makes database management easy for those people who don’t have in-depth knowledge of the topic.

Creating Databases 

From the main control panel menu click the "MySQL Databases" icon and then click the "Create new Database" link.

Choose a Database Name that helps you remember what the database is for.  For example, enter "chat" if the database is intended to be used with a chat script.  The database name is always preceded by your username and an underscore.  If you chose "chat" for a name, the actual database name would be username_chat.

The Database Username is the login name for the database.  It may be the same as the Database Name.  In the above example, we chose a different login name (gary).  As with the Database Name, the Database Username is also preceded by your username and an underscore (username_gary in this case).

After you have selected the database name and username, enter a database password and click the "Create" button.

Removing Databases

A list of all databases is present in the main MySQL databases menu.  To delete a database, check the box next to the database name you want to delete and then click the "Delete Selected" button.  In the above example, we are deleting the database named username_data1.

Adding Users to a Database

There may be times when you want to have more than one login name and password assigned to a database.  To add additional users to a database, follow these steps:

1.  From the main database menu, click on the name of the database you want to modify.

2.  Click on the "Create New Database User" link at the top of the screen.

3.  Enter a username and password and then click the "Create" button.

You can see how many users each database has from the main MySQL databases menu.

Removing Users from a Database

To remove database users, first click on the database name from the main MySQL databases menu.  In this example we have clicked on the "username_chat" database, which has two users (see above picture).

The username_chat database has two users: username_chat (the username is the same as the database name) and username_gary2.  To delete the database user, simply check the box next to its name and click the "Delete Selected" button.

Changing Database Passwords

To change a database password, first click on the name of the database in the main MySQL databases menu.  The list of database users will appear (see above picture).  To change the password for the database user, click the "modify" link and enter a new password, then click the "Create" button.  You do not need to know the old password to make this change.

Setting up your Database with Scripts

Most scripts need to know four things about your database: the database name, database username, password, and hostname. 

The database name always takes the form as ControlPanelUsername_DatabaseName, where ControlPanelUsername is the sign in name you use to access the control panel.  The DatabaseName is the name you give to the database from the MySQL databases menu.  For example, if you sign into the control panel as "gary" and create a database named "count," the true database name is gary_count — you will want to enter this database name into your script configuration.

The database username can be the same as the database name or you may choose a different username for the database.  The database username takes the form of ControlPanelUsername_DatabaseUserName.

The database password is set during database creation.  The password should be different than your control panel password.  The script will need to know the database password in order to modify the database.

The hostname tells the script where to access the database.  Usually this is designated as ‘localhost’ because the script and database are located on the same server.  If the script doesn’t allow a text entry in the hostname configuration, enter the IP address of your site.

Note: 

After you create a database, the control panel will take you to a screen that gives you all this information.  Simply take the values from this page and enter them into your script configuration.

Accessing phpMyAdmin

phpMyAdmin is a tool written in PHP that allows you to administrate your MySQL databases.  You can execute SQL statements, work with fields (add, edit, delete), work with tables (create, alter, drop), create additional databases, and much more.  phpMyAdmin is intended for advanced users.  Most PHP scripts will automatically setup the database for you, so you probably won’t need to use phpMyAdmin..

phpMyAdmin can be accessed at http://www.yourdomain.com/phpMyAdmin.  Please visit http://www.phpmyadmin.net for more information on using phpMyAdmin.

Incoming search terms:

database link mysql,create database direcadmin,mysql information in directadmin,add host mysql directadmin,How to change SQL Admin Directadmin,how to run sql query directadmin,mysql add user,mysql directadmin users,path for mysql databases on direct admin server,path to phpmyadmin under directadmin,php delete database directadmin,php script directadmin create subdomain,php sql direct admin,where are the sql databases in directAdmin,how to change mysql setting direactadmin,directadmin tutorials,change database name in phpmyadmin,direct admin all databases,direct admin connect mysql from other host,direct admin how check mysql host,directadmin create db user without underscore,directadmin how to change database,directadmin mysql underscore,directadmin php mysql tutorial,directadmin phpmyadmin path,directadmin remove mysql,directadmin subdomain database ekleme,добавить sql directadmin

1. INTRODUCTION

1a. Introduction

LXadmin “Host in a box” is the only control panel that makes use of Lighttpd and DJBDNS which only uses 8 MB of RAM with a freshly installed system. The control panel itself uses 1 MB of RAM when idle. LXadmin “Host in a box” is part of LXadmin, the leading light-weight control panel in the industry. The only difference between the two is the use of different daemons.

This lightweight control panel has all of the features included in all leading control panels such as mail, spam filter, PHP, CGI, Perl, SUexec, FTP, MySQL and much much more. You will get to find out more in this document as you read.

---

2. THE BASICS

2a. Accessing the control panel

There are several ways to access LXadmin: http://yourdomain:7778 – You can access the control panel through any hosted domain by putting :7778 at the end of the domain. https://yourdomain:7777 - You can access the control panel securly using SSL through any hosted domain by putting :7777 at the end of the domain. http://192.168.0.1:7778 or https://192.168.0.1:7777 - You can access the control panel through any IP address allocated to the server.  This is useful when your domain transfer has not yet propagated. A window (top right image) will appear.  Enter your username and password and you should have successfully logged in.

2b. Changing your password

To change your password, click client home and then on the top right corner, you will see the password tab. Click on it and fill in your existing password and the new password twice and click Update.

2c. Adding a DNS Template

You have to add a DNS template initially. DNS template is the DNS configuration which will be copied to your domain’s DNS when a new domain is created. For adding a DNS template, you have to basically specify the primary and secondary nameservers for the domains you are planning to create on this server. For instance: ns1.lxlabs.com and ns2.lxlabs.com . The name is simply an identifier which will be used later when creating the domain.

For creating a new DNS template,

go to “Client Home” page and under “Domains“, click the “DNS Templates” icon

In the DNS Templates page, you can see the list of existing DNS templates. If you do not have any existing DNS template, create a new DNS template by clicking the “Add DNS Template” tab on the top.

In the next page, enter the DNS information for the template:

Click the “Add” button and the new DNS template is created. You can see the new DNS template in the list of DNS Templates

Click on the new DNS Template name to edit DNS records like NS, A, CNAME, MX and TXT

2d. Add a Reseller

Before you proceed to add a new Reseller, you have to add a new plan for the new client/reseller
To add a new plan,

To add a new plan, click “Client Plans” icon

In the next page, click the “Add Client Plan” tab.

Here you can enter the plan details like:

Client Plan name)
Description of the plan
Number Of Clients allowed
Number Of Domains allowed
Disk Usage (in MB)
Number Of Subdomains allowed
Mail Disk Usage (in MB) limit
Number Of Autoresponders allowed
Number of Mail Accounts allowed
Number Of Mailing Lists allowed
Traffic (in MB per Month) limit
Maximum number of MySQL Databases
Maximum Number Of Domain Users
Ability to add more domains
Ability to set Disabled URL
Ability to Enable Ssl
Ability to Enable Statistics
Ability to Enable Cgi
Ability to Enable Php
Ability to Enable Asp.net (ignored On Linux)
Allow Scheduler Management or not
Allow Backup Scheduling or not
Allow Backing Up or not
Can Manage DNS or not

Once you have created the plan, go back to the “Client Home” page and click the “Clients” button link

This page will list your existing customers and resellers. If you do not have any, click on either the “Add Reseller” tab that you see on the top.

In the “Add Reseller” page, enter a name for your Reseller, password and email address.
If you enable the “Send Welcome Message” check box, an email with the account details will be sent automatically to the Reseller’s email address.
Select the plan you have created earlier and click “Add” button.

Now in the “Clients” page, you should be able to see the new Reseller that you have created:

Incoming search terms:

LXadmin,kloxo tutorial,LxAdmin tutorial,max smtp instances kloxo,kloxo change email password,There are no Dns Templates in the System You have to have at least one Dns Template to add a domain/client,how to configure kloxo dns template,there are no dns templates in the system you have to have at least one dns template to add a domain/client click,kloxo tutorials,kloxo manual,manual kloxo,kloxo edit spam message,add external domain to use smtp server kloxo,not appear www cname lxadmin,kloxo max smtp instances,lx admin,lxadmin spam,kloxo change admin email,kloxo webmail ssl,kloxo enable cgi,kloxo web hosting tutorial,kloxo total disk usage,kloxo toturial,set ip to client kloxo,kloxo reseller guide,lx admin tutorials,kloxo spamfilter,kloxo set server traffic limit,kloxo tutoriale,kloxo welcome mail,kloxo webmail tutorial,kloxo smtp mail server,kloxo use asp,kloxo subdomain config dns,lxadmin modify welcome mail,there are no dns templates in the system you have to have at least one dns template to add a domain/client click here to add a dnstemplate,tuto kloxo,tutorial de kloxo,tutorial lxadmin,tutorial Max Smtp Instances,tutoriel kloxo,webmail dns kloxo,welcome to kloxo change,welcomw message kloxo,where you can find the mx record in the koxo panel,configuring client plans in koxo,there are no dns templates in the system,lxadmin spam mail,tutoriales de kloxo,max domains lxadmin,no access ftp kloxo,reseller hosting tutorial,setting dns subdomain kloxo,setting email kloxo,smtp en kloxo,smtp kloxo check,what is lxadmin panel smtp address,kloxo panel tutorial,acessar webmail lxadmin tutorial,create backup kloxo,create mailing list kloxo,edit dns settings kloxo,edit kloxo welcome message,enable cgi in kloxo,filter email on kloxo,here are no dns templates in the system,how ti set domain in kloxo,how to add cname dns kloxo,how to add kloxo wholesale reseller,cpanel to kloxo tutorial,clients access Kloxo,add allowed domaine on smtp kloxo,add dns template for admin kloxo,add domain for admin kloxo,add smtp to kloxo,admin {domains} kloxo,agregar dns a ip lxadmin,allow external domain to use smtp server kloxo,añadir ssl con kloxo,asp on kloxo,backup your entire account with kloxo,how to configure ssl client kloxo,how to create smtp server kloxo,kloxo domain control panel,kloxo external dns,kloxo lxadmin smtp server setup,kloxo mail client configure,kloxo mail client setup,kloxo mail configuration,kloxo mail server configuration,kloxo make client admin,kloxo manual backup,kloxo panel mail spam problem,kloxo dns template from external name server,kloxo dns external email,how to find webmail kloxo problem,how to see the kloxo password from back end,indovps kloxo dns subdomain,kloxo add admin,kloxo add dns record subdomain,kloxo admin panel,kloxo configure externall mail,kloxo difference between reseller and customer,kloxo disable spam filter,kloxo dns admin email,kloxo panel spam mail problem

Joomla! adalah Sistem Manajemen Konten (SMK atau CMS) yang bebas dan terbuka (free opensource) ditulis menggunakan PHP dan basisdata MySQL untuk keperluan di internet maupun intranet. Joomla pertamakali dirilis dengan versi 1.0.0. Fitur-fitur Joomla! diantaranya adalah sistem caching untuk peningkatan performansi, RSS, blogs, poling, dll. Joomla! menggunakan lisensi GPL.

Asal kata Joomla sendiri berasal dari kata Swahili yang mengandung arti “kebersamaan”.

Prinsip Dasar Joomla

Secara garis besar dan gamblang, Joomla! terdiri dari 3 elemen dasar, yaitu server web (webserver), skrip PHP dan basisdata MySQL. Server web diasumsikan terhubung dengan Internet/Intranet yang berfungsi sebagai penyedia layanan situs. Skrip PHP terdiri dari kode program dalam bahasa PHP dan basisdata merupakan tempat penyimpanan konten. Joomla menggunakan Apache sebagai server web dan MySQL untuk basisdatanya.

Pertamakali, pengguna meminta akses terhadap halaman Joomla dengan mengeksekusi URL pada browser web yang kemudian terhubung dengan server web. Permintaan ini yang dalam istilah teknis lebih dikenal dengan query string selain terdapat URL juga mengandung parameter konten (section, category, ID article dan lain-lain). Berdasarkan parameter tersebut, sistem skrip Joomla melakukan kontak dengan basisdata dan mengambil konten yang dimaksud berdasarkan parameternya. Terakhir, konten dan templat (template) digabung bersama dan kembali sebagai halaman html, gambar, css dan javascript.

Paket Joomla! terdiri dari beberapa bagian yang terpisah dan termodul yang sangat fleksibel, dapat dengan mudah dikembangkan dan diintegrasikan. Sebagai contoh “plugins” WikiBot yang memperbolehkan penulis di Joomla menggunakan “Wikitags” pada bagian artikel yang fungsinya secara otomatis membuat pranala dinamis ke artikel Wikipedia pada saat ditampilkan. Ada lebih tersedia 1,700 “plugins” yang secara resmi didelegasikan oleh OpenSourceMatters tersedia di http://extensions.joomla.org/ dan saat ini secara resmi dipindahkan ke http://joomlacode.org dengan dukungan server yang lebih lengkap.

Riwayat Joomla

Pada tanggal 17 September 2005, diluncurkan Joomla versi awal yaitu 1.0.0 yang merupakan versi alias dari Mambo 4.5.2.3 yang dikembangkan oleh “Pengembang Inti Mambo hingga Agustus 2005″ yang hengkang dari Mambo.

Pemimpin Tim saat itu Andrew Eddie yang dikenal dengan sebutan “MasterChief” menulis surat terbuka di komunitas dan diumumkan di forum mamboserver.com. Tim pengembang kemudian membuat situs OpenSourceMatters untuk mendistrubusikan informasi ke pengguna, pengembang, desainer web dan komunitas lain pada umumnya.

Perkembangan Joomla berawal dari Joomla 1.0.0 sampai dengan tahap yang luar biasa yaitu Joomla 1.0.15. Namun seiring dengan perkembangan versi Joomla 1.0.x ini, sekitar tahun 2007 telah dimulai pengembangan Joomla 1.5.x yang memiliki beberapa persamaan dan perbedaan yang cukup signifikan. Saat ini Joomla 1.5.x telah mencapai pada tahap Joomla 1.5.8.

Masing-masing punya daya tarik tersendiri, Joomla 1.5.8 menawarkan nuansa baru dan lebih modern termasuk dalam systemya. Sedangkan Joomla 1.0.15 lebih stabil dan terdukung oleh banyak aplikasi dan developer.

No.	Versi	Tanggal Diluncurkan	Nama Kode
1.	1.0.0	17 September 2005	Sunrise
2.	1.0.1	21 September 2005	Sunburst
3.	1.0.2	2 Oktober 2005	Sunset
4.	1.0.3	14 Oktober 2005	Sunlight
5.	1.0.4	21 Nopember 2005	Sundial
6.	1.0.5	24 Desember 2005	Sunspot
7.	1.0.6	15 Januari 2006, 16:00	Sunscreen
8.	1.0.7	15 Januari 2006, 21:00	Sunburst
9.	1.0.8	26 Februari 2006	Sunshade
10.	1.0.9	5 Juni 2006	Sunshine
11.	1.0.10	26 Juni 2006	Sundown
12.	1.0.11	29 Agustus 2006	Sunbow
13.	1.0.12	25 Desember 2006	Sunfire
14.	1.0.13	2007	Sunglow
15.	1.0.14	2008
16.	1.0.15	2008
15.	1.5 Stable	22 Januari 2008	Stable

Seperti yang disampaikan oleh Pihak Pengembang Inti Joomla, Joomla 1.0.x akan berakhir pada Joomla 1.0.15. Tidak ada support dan pengembangan selanjutnya. Dan mereka akan berkonsentrasi pada Joomla 1.5.x. Pengguna Joomla dapat melakukan installasi pada server kami dengan manggunakan Fantastico auto installer

Incoming search terms:

pengenalan joomla,rss feed for joomla 1 0,tutorial joomla 1 5 8