How to open mysql in denver. Databases and phpMyAdmin in Denwer

Changing your website's favicon is a relatively easy task.

1. Create a 16x16 pixel image. You can use any graphics editor, such as Photoshop, Gimp, Paint.net, or Windows Paint. Alternatively, you can also use tools found on the internet such as http://antifavicon.com.
2. Convert [image you created] to ico format using one of the following free sites:
3. The file you create in this way will have the .ico extension. Copy this file to /joomla/templates/ directory<Вашего шаблона>And name it favicon.ico .
4. Open any browser. Do you see your new icon? If yes, then congratulations. If not, it doesn't necessarily mean that you did something wrong. Browsers are designed to keep data traffic to a minimum so they don't refresh the favicon every time a web page is displayed. Even refreshing the web page (F5) won't help. So you need to refresh [web page] more carefully:
   • [For browsers] Mozilla/Firefox/Safari: press and hold down Shift key while clicking on "Refresh" at the same time or press Ctrl-Shift-R (Cmd-Shift-R for Apple Mac);
   • IE: hold [key] Ctrl while clicking Refresh, or press Ctrl-F5;
   • Konqueror: just click on the "Refresh" button or press [on the key] F5;
   • Opera: Users may have to [perform] a full cache clear in Tools→Preferences.
   • Chrome: Shift-F5
   • If this does not work, then you will need to delete temporary internet files and history, and then reopen your web page.

My favicon is stored elsewhere

Some templates contain code that redirects the browser to a different directory or favicon file. To determine where your new favicon should be stored, explore http://yoursite.com/templates/yourtemplate/index.php and look for the code containing the text

< link rel = "shortcut icon" href = "http://yoursite.com/templates/your_template/icon/favicon.ico" />

If you don't want to just change the file favicon.ico in the directory of the corresponding template, you can find a mention of the file favicon.ico in document html.php. Path to it: "........\libraries\joomla\document\html\html.php". This will prevent this icon from switching when you use

< link rel = "shortcut icon" href = "http://yoursite.com/templates/your_template/icon/youricon.ico" />

V html code template and [unless] you have deleted the [old] favicon.ico file (why call this icon twice?).

// Try to find a favicon by checking the template and root folder$path = $directory . D.S.; $dirs = array ( $path , JPATH_BASE . ds ); foreach ($dirs as $dir ) ( $icon = $dir . "favicon.ico" ; if (file_exists ( $icon )) ( $path = str_replace ( JPATH_BASE . DS , "" , $dir ); $path = str_replace ( "\\" , "/" , $path ); $this -> addFavicon ( JURI :: base (true ) . "/" . $path . "favicon.ico" ); break ; ""

Denver provides a unique opportunity through which it is possible to turn a computer into a server. Unfortunately, you have to put up with the fact that such a site or blog will function exclusively on this PC, but nevertheless, such a test site acts as a unique tool in order to fully understand the engines. In addition, Denver allows you to learn create a database. If you also have a desire to learn how to properly create a database in Denver, we recommend that you familiarize yourself with some secrets, after learning which all actions will become accessible and easy to perform.

The algorithm for creating or deleting a database in Denwer is clear even to a beginner.

If creating a database in Denwer is a top priority for you, there are only a few sequential steps that will lead to the achievement of the goal you have set. Of course, you will have to start with what you need to find and download Denver program itself, install it on your computer. Only after completing this minimum preparatory work, you can proceed to the next steps.

Create a folder

Open "Computer" go to local drive C, there you will find the WebServers folder, click on it to open it. Inside it you will see a few more subfolders, among which there will also be a subfolder "Home", move to it. Now, being in this space, you should independently create any folder in which you intend to store the files necessary for the functioning of the site. In particular, we create a folder called "Testewp.ru". This means that we have already come up with the name of the site - http://testewp.ru.

Inside the “Testewp.ru” folder we created, you need create another folder, whose name will consist of three letters w. In the created “www” folder, unzip the files of the engine that runs your site, in particular, WordPress.

Database creation

Minimize, or even better, close all unused windows. On the desktop, you will find shortcuts that were created by the Denver program. Among these shortcuts, find Start servers, click on it to activate this process. Do not be afraid that the screen of your computer will “wink” at you a little intimidatingly. In particular, twice you will have to contemplate the emerging black windows.

After that open any browser and enter the link in the address bar - http: //www. localhost/. By clicking on the link, you will find the “Utilities” parameter on the page that opens, follow it, find “Introducing new MySQL databases and users”.

Now a kind of questionnaire will open in front of you, which, of course, you will have to carefully fill out.

All fields are best filled with the same phrase corresponding to the name of the site we created - testewp. It is important to leave blank only the first line regarding the administrator password. Then it remains to click on the "Create database and user" button. You won’t even notice how the Denver program will reload the page on its own, after which the database will be successfully created, about which you will be greeted with the corresponding phrase.

ATTENTION. As you can see, creating such a database turned out to be quite simple.

Along with the need to create a database, there is a need for its same quick removal. For this reason, users are actively interested in how to delete the database on Denver.

Of course, you can act as standard and simply delete the database, but then later you will have to seriously pay for such a rash action, because with each next attempt to create new base you will have to meet a warning that such a user already exists, and, accordingly, at the same time meet a refusal.

In order not to face such technical problems, it is important to follow a different path. Initially, in the program, you should click on the "Users" tab, find there what you want to delete. Next at the bottom open window in the checkbox next to the phrase "Delete databases whose names match usernames", check the box, and then click on the "Ok" button.

After the process is completed, Denver must be closed, then reopened, and only after that proceed with the creation of a new base.

So, the process of creating and deleting a database can be mastered by someone who just reads the instructions carefully at least once.

Website development course with engines

I decided to create a separate category for studying the following three engines: WordPress, Joomla and Drupal.

Each of them has its own zest. WordPress can be called a favorite among webmasters. No wonder it has been used for blog building since kindergarten. But not as simple as it might seem at first glance.

Joomla is the most common and very convenient when creating websites, at first everything is so confusing, but it only seems.

Drupal, rather love for life. It has huge prospects and the best user support. You can create a project of any complexity.

Today we will be testing the wordpress engine on a local machine. This means that we do not need to buy a domain and hosting - all this will be on our computer thanks to denver.

Denver is a program that will transform our local computer to the server. You can download the distribution kit from the Denver website.

True, and the created site will be available for viewing only on this computer, and not for Internet users. But this is what we need. We will make a test site or blog to deepen our knowledge of the engines and finally learn how to create a database, a MySQL user.

Create a test site:

1 step. Install Denver.

All instructions are on the denver website, and you can also read the forum if you have problems.

2 step. Create a folder to store test site files.

• To do this, go to the folder where Denver is installed, by default this path C:\Web Servers.
• Then go to the folder home and create a folder for our site files in it, for example testwp.ru. We have created a site name and it will have an address http://testwp.ru.
• Now go to the folder testwp.ru and already in it we make a folder with the name www. Here in this folder www and you need to unpack the files of wordpress or any other engine.

3 step. Creating a database in Denver.

Step-by-step instruction.

Our engine works with the base MySQL data, which is included with Denver.

1. Denver has created shortcuts on the desktop, find and run start servers. Two black windows will quickly appear and disappear on the computer screen, do not interfere with them, then launch the browser and type in the address bar: http://www.localhost/
2. Find the heading on this page Utilities where follow the link Setting up new MySQL databases and users.
3. Fill out the web page that opens like this:

• MySQL Administrator Password:<оставьте пустым>
• Database name: testwp
• User login: testwp
• Password: testwp
• Password repeat: testwp
• And push the button Create database and user.

4. The page will be reloaded imperceptibly for your eyes and after the title the inscription will appear: database and New user started

5. So simply and quickly we created a database called testwp, login and password will be used to access the database testwp.

4 step. Installing the WordPress distribution.

1. Unzip the package to an empty directory. I answer where this empty directory is. This is the www folder created in Denver.
2. Open wp-config-sample.php in any text editor and fill in your database connection information.
3. Save the file as wp-config.php
4. Download everything.
5. Open http://your_site/wp-admin/install.php in a browser. This script will create the tables you need for your blog. If an error occurs, double-check your wp-config.php file and try again.
6. Remember the password given to you.
7. The install.php installation script will redirect you to the login page. Log in as admin with the password created during installation. You can click on "Profile" to change your password.

Thus, you can create a test site on any engine.

See other thematic lessons or articles, they are also cheat sheets. These articles have already been published early and will greatly complement my new column: The course of creating websites with the help of engines.

(Denwer) . Today we will continue our lesson from the series " Installing and configuring a local Denver server (Denwer)". After installing Denver, the next step is to set it up. The first step is to set up the Denver database. It uses (Free Database Management System) DBMS MySQL. To set up, the local server database is used in Denwer phpMyAdmin.

phpMyAdmin is an open source utility written in PHP that provides full, including remote, administration of MySQL databases through a browser.

Launch Denver using the desktop shortcut and type http://localhost/tools/ in your browser.

Click on phpMyAdmin and go to home page phpMyAdmin in Denver.

On the left side is a list of available MySQL databases data in Denver. I have as many databases here as there are sites on Denver. Of course, you can use one database for several sites, giving each site its own prefixes. But if the Hosting provider does not limit the number of created databases, of course it is better to create a separate database for each site. A phpMyAdmin Denver allows us to create an unlimited number of databases. To create a database in MySQL in Denver, go to the tab (databases) enter the name of the database. It is better to enter a clear name so that it is not difficult to understand from the name which site this or that database belongs to. It's important when you accumulate a large number of databases. I recommend creating a database with the name of the site so as not to get confused later. The neighboring drop-down menu can be left by default (comparison), or you can select from the drop-down list " utf8_general_ci". "utf8_general_ci" is the main character set of the "UTF-8" encoding. "UTF-8" - the best option coding on which to create a site. In this case, you will not have problems with the encoding, when the Cyrillic alphabet is displayed with question marks and it is not clear what kind of gibberish. This encoding supports both Cyrillic and even Chinese characters. Click (create).

A database with your name will appear in the left item of the phpMyAdmin panel.

Click on the name of our database and get into the database itself. Now we need to create a new user. To do this, we need a tab (privileges).

By clicking on this menu, we get to the MySQL accounts page in Denwer. For the Denver database, one account is enough, since our local server(localhost) is on our computer. No one will get to it except us. And for real hosting, it is better to create a separate account. After the user table, there is a link "Add user".

By clicking on it, we go to the pop-up window for adding a new MySQL user to Denwer.

Enter the username in the first field. In the second field "Host" from the drop-down menu, select "local", as a result, "localhost" is automatically entered. In the following fields, enter the password as usual. In the "Database for user" block, leave everything as it is, and go to the "Global privileges" block. Here we choose what privileges we will give to this user. Since we are the owner of this local server, we click on the "Mark All" link and at the bottom click on "Add User". After successfully adding a new user, go to the "Privileges" page again to make sure that a new user has been added to the Denwer database.

Now the database has been created and we can proceed to Joomla CMS installation.