Hi all! In today's article, I will tell you about installing and configuring a local Open Server on your computer.
With the help of Open server you can test on the local machine (i.e. on your computer) any changes related to the creation of sites in and Php (self-written sites).
If you are a Denver fan, then I have an article.
Beginning of work
The very first thing we need to visit is the official website of the local server developer, which is located at this address - http://open-server.ru
In principle, we do not need to download the maximum edition package (504 MB). The second, more compact version with the necessary settings for creating a local server on a computer is quite suitable for us. That's why I choose it.
Enter in the "Code from the image" field and click on the "Download" button
I want to warn you to be patient, because choosing the second option will make your files download very slowly. It took me about 2 hours with dedicated internet. In principle, you can be even more cunning and upload all files through Rutreker. A tricky marketing ploy by the developers 🙂 Well, okay, let's move on.
Installing Open Server to Disk
Go to downloads and double click on our downloaded file. Next, you will be prompted to select the path where the local server will be installed. I will leave it unchanged, because I have only one disk - the disk c:\
Then unpacking will follow. We go to our directory where we installed Open Server and click on the appropriate icon (I use a 64-bit OS). We choose "great and mighty" as the language.
Next, a dialog box will appear telling us that this is the first time it is running on the computer, which will offer to install Microsoft Visual C ++ Runtime & Patches. We agree and continue to work. This process may take some time.
After installing the local Open Server, you will see a red flag in the system tray.
Right-click and select "Run"
After starting, you may get an error that the port to which the server is accessing (80 and 443) is already occupied by another program, in most cases it is Skype. The solution is the following. Go to Skype - Tools - Settings.
In the “Settings” section, you will need to go to the “Connection” sub-item and uncheck the checkbox “For additional incoming connections, use ports 80 and 443”. Save your changes.
After these manipulations, let's try to open and launch the Open Server window again. And voila! Everything is working.
Creating a new site on a local Open Server
Great, the program has been launched, now we need to create a new site and see how it works on our local hosting. To do this, go to the Open Server itself and its domains folder (domains or folders of our future sites).
Go inside and just click "Create a new folder".
There is already a site in the Domains directory called localhost. You can go to the browser and type this name into the address bar.
We will see a welcome message telling us that the server is running.
Now let's create our own folder with a new site and call it - test.loc. LOC will tell us that the site is on the local machine.
Inside it, through any text editor, we will create a simple php file - index.php
The index.php file itself can be created through a text editor or is also called a code editor - Sublime Text.
Now we go down to the very bottom of the window to the system tray area (where the Windows clock is located) and start our server.
After a successful launch, we again go to the Open Server in the tab my sites and select our local one - test.loc
Now let's go to the browser and see the result of the output of the php code on the page.
Important! There is one very important nuance: you can have an icon on that everything is working, a message appears, shown in the screenshot above. Here lies the error. If your site has php or scripts, they WILL NOT work! This is because many antiviruses, such as Kaspersky and others, regard the launch of Open Server as a virus and block the operation of all scripts. Before a session, just disable your antivirus and then everything will work fine for you. This is so, for information.
That's all my dear friends! I think that you will be able to set up your local Open Server and test your future sites without any problems. Thank you for your attention, see you soon.
Do you know that in order to make a website, it is not necessary to immediately buy a domain and hosting for it? You can get by with installing a special set of programs for Windows - a local server.
I consider Open Server to be one of the best options, or rather its OSPanel Premium version.
This free version includes only the necessary set of programs to work with a local server.
Download, install, by default the program is installed on the C: \ OSPanel drive, go there and create a shortcut for the exe file corresponding to the version of your Windows, you can see it in the computer properties. If Windows is 64bit, we make a shortcut for it (Open Server x64.exe). Next, in the properties of the shortcut, you must specify the launch as administrator, this is important. We start, we have a red flag in the system tray, click on it and then on the green one - Run. We wait a little, if the checkbox turns green - you are very lucky, if not - most likely the reason is in the antivirus program, which does not allow you to change the system hosts file. There is no universal recipe for all antiviruses, but what we can do is add our server to the trusted antivirus applications, or disable monitoring of the hosts file. Here, either Google will help you, or we demolish your antivirus and set, for example, the free Kaspersky Free Antivirus, add our Open Server x64.exe to the trusted ones, everything should work.
When the flag is green, the server is running. We go into the settings on the modules tab and select Apache-2.4-x64, PHP-5.6-x64, MySQL-5.6-x64, if Windows is 32 bit, then we install the same versions without x64. The rest are all unchecked. These settings are currently optimal for most popular CMS (Worldpress, Joomla, Prestshop, OpenCart...). We restart, everything is ready to work if the flag is green. If not, write in the comments, I will help.
Installing any CMS on Open Server
Many popular CMS engines like Worldpress , Joomla , Prestshop , OpenCart ... are installed in much the same way.
Want to see everyone? Yes, easily, here is a universal instruction for you:
Download CMS. We go to ospanel\domains through the menu - Folder with sites or through the explorer, create a folder there with a local domain name, for example: presta-pro.ru, unpack our CMS there, right to the root, after unpacking we have a bunch of files in this folder and not another folder.
Through the OpenServer menu (when the flag is green), click - Advanced - PhpMyAdmin, User: root, Password: (leave empty). In the menu on the left, click - Create a database
Name: (database name in Latin, for example:) namedb, Comparison: utf8_general_ci, click - Create.
During installation, you will be asked to provide:
- Database name: (previously created) namedb
- Database password: empty, I hope you can fill in the rest of the fields yourself, well, unless the host can still request: localhost
- After installation, some CMS ask you to delete the install folder, it is located in the root of our site, you need to delete it through Windows Explorer.
At the end of the installation, it is important to remember three things:
- Path (address) to the admin panel,
- Login (may be email to login),
- Password.
The path to the admin panel can be unique, so we bookmark it. It is advisable to remember the login and password using LastPass.
Everyone, congratulations, you just created a website, or maybe several at once. The advantage from the point of view of SEO of this approach is that search engines do not like raw and unfinished sites, and on a local domain, you can bring the site to a working state and only then upload it to the Internet, to hosting. Yes, and you can practice and choose CMS to your liking. And in the following articles we will consider their configuration in more detail.
P.S. Configuring Open Server + Dr.Web
After starting Open Server, a couple of Dr.Web windows will pop up, in which we allow access to OpenServer and Apache, but then dr.web still does not allow starting Open Server. To open additional settings, you need to click on the closed lock icon, then the gear, then allow changes to the host file for OpenServer, as in the photo below, after which the server still started.
P.S. Setting up Open Server + Avira
Another good antivirus, including a good free version, can easily make friends with OpenServer. We launch the antivirus, click the gear in the lower left corner, and uncheck the box in the settings, as in the picture.
Installing and configuring openserver. Detailed instructions on how to install and start creating your first website using open server.
Probably, many have already heard about such a wonderful little thing as open server
What is OpenServer? This is a software package consisting of Apache, MySQL, PHPMyAdmin (I called these the main ones), which is installed in one fell swoop (one program - in which there are many programs, roughly speaking)
If you yourself tried to install Apache first, then MySQL, then phpmyadmin, you would have spent a lot of time and effort (thanks to the author of this product!)
And then there are a bunch of necessary add-ons in the form of Nginx, PostgreSQL, Memcached, IonCube and a bunch of necessary things for people who create websites
Let's talk about the convenience of Open Server before installation. Firstly, it is compact, does not take up much space, has a convenient menu and contains there is nothing superfluous (almost =D). This is what Open Server looks like after launch
As we see starts Open Server in tray without taking up space on the taskbar
Let's see main advantages of Open Server ahead of Denwer and other Windows products. First, the documentation. Openserver has documentation for almost all components 
And even though it was made in the form of links to other sites, it still exists. And if necessary, we can go to the site and read the information we need
let's go further
The second plus of this program. The necessary programs that are often needed to create a site are already in the Open Server package itself. You need Notepad - please, PDF viewing - also available, taking screenshots, editing icons, even disk analysis and a port monitor are here (but why =D)
FileZilla FTP client, portable Google Chrome, portable Firefox, even Skype and TeamViewer. It can be seen that the creator of the project really did his best. He definitely deserved thanks for such a killer-comfortable set called open server
Excellent! Let's install it. Download link below
https://ospanel.io/download/
So, install Open server
Launching on behalf of the administrator Open server. You will be prompted in which folder to install it.
For this tutorial, I put Open server on the test computer, so I unzip to the C: drive (because there is no other one) 
After unpacking, the Openserver folder appeared on the disk specified during installation (in my case, the C :) drive - we will need it in the future. Let's open it. We see 2 files. Open Server x86 and Open server x64. You need to run the file, depending on the bitness of your system (I don't know my bitness?)
I have 7 64 bit, so I run Open Server x64.exe (preferably as administrator) 
By the way, you can immediately throw the desired shortcut (32 or 64) on the desktop 
When starting, we specify the language in which it will be convenient for us to read the translation of the Open Server program. I will choose Russian 
Whether to install Visual C++ is up to you. But it's better to install, so that everything works 
After installation, restart your computer 
After reboot again start Open Server. Since I dropped the shortcut to my desktop, I will launch it from there 
After launch, need to go to tray(as the Open server is started in the “Shut down” mode) and confirm the start
When the checkbox Open Server turned green, then our Open Server is running, and we can start working with it 
So let me show you the basics. open server that will be of interest to you
How to get into phpmyadmin in Open server
In order to get into phpmyadmin, you need to type in (Open server must be running) line of the browser
http://127.0.0.1/openserver/phpmyadmin/index.php
Or go to Open Server setup and click on phpmyadmin 
User: root No password 
How to create a new site on Open Server
Let's create a new site on Openserver (see how I try for you)
I download the latest Joomla from the office. site 
I create a test folder in the localhost folder 
Unzip, from the Joomla archive, all the files to our test folder 
Now we can start installing Joomla. To do this, enter in the browser line (test - due to the fact that we created the test folder in localhost. If we had created the nos folder, it would have started localhost / nos)
localhost/test 
That's all for today! I hope you enjoyed this lesson!
Greetings, friends! 🙂
Today we have on the agenda again the WAMP build of OpenServer and MySQL, which is included in its kit, beloved by many (including me).
With this software, as well as its features, I first introduced the readers of this blog in one of my first articles on .
The idea of creating today's article came to me while writing publications about working with MySQL in the console, when working with which OpenServer has its own subtleties.
In addition, in practice, situations often arise when you need to change the MySQL server settings and debug operations with the database using logs. In such cases, when working with OpenServer, novice users usually have a lot of questions (as I had in my time).
Therefore, today you will be waiting for answers to them 🙂
And also I will briefly go through the tools for working with the MySQL database in OpenServer, which provide a convenient graphical interface for manipulating data, and touch on working with MySQL in the OpenServer console.
In a word, today you will find an overview of the full cycle of working with MySQL when using OpenServer.
Let's go 🙂
Selecting MySQL version in OpenServer
A feature of OpenServer is that it includes not only many different server components, but also various versions of them.
This, I must say, is very convenient, because. in some cases, you need to use outdated software for local deployment of legacy projects (very, very old) that need to be supported.
And at the same time, to start new projects, you will need to use everything fresh 🙂
That's when switching MySQL versions will come in handy, so that we can work with different projects when using one OpenServer distribution, and not install it for each separate one.
So, to select the required version of MySQL in OpenServer, after starting the program, click on the tray icon and select the main menu item Settings:
After that, the following window will appear on the screen, in which you will need to go to the tab Modules:
And here, in the drop-down list with the values of the MySQL / MariaDB field, select the required version of MySQL or MariaDB, which, as you know, is a fork (from the English fork - a branch) of MySQL, working with which is no different from its parent.
Even the tools are the same :)
After selecting the version, a window will appear on the screen about restarting OpenServer, which is necessary for the changes to take effect.
We restart and you can work with the new version.
In this menu, in addition to choosing the required MySQL version, you can, by the way, completely disable the use of this DBMS when working with OpenServer. How it is done, for example, with PostreSQL in OpenServer by default.
An important point when using several versions of MySQL and other server components that are part of OpenServer at the same time is the need to configure each version separately.
This is because there are separate configuration and log files for each version of MySQL, which will be demonstrated next.
Also, a database created using MySQL 5.7, for example, will not be available when working with MySQL 5.5.
Therefore, I ask you to take this fact into account and not be surprised at the reset of your settings and the loss of the database. However, don't worry, your data hasn't disappeared without a trace.
If you select as the current version of MySQL the one that you carefully configured and for which you created your databases, everything will return back 🙂
MySQL logging settings in OpenServer
Quite often, when searching for various bugs, and just to track operations with the database, you need access to the MySQL server log files.
There are two ways to view the MySQL logs running as part of OpenServer: through the OpenServer interface and by opening log files stored on the hard drive.
For the first method, you need to open the familiar OpenServer management menu by clicking any mouse button on the OpenServer tray icon and select the item View logs, then the following dialog box will appear on the screen:
By default, OpenServer only logs errors and events on the MySQL server itself, as you can see in the screenshot above.
However, what to do if you need a list of SQL queries to databases located on the server?
Fortunately, OpenServer provides the possibility of advanced logging, upon activation of which queries to the database will be written to a separate log.
To enable logging of requests to the MySQL server in OpenServer, you need to perform the steps familiar to us today: OpenServer Control Menu -> Settings -> Modules.
And next to the drop-down list with the values of the MySQL / MariaDB field, check the box keep a request log:
On my own behalf, I want to add that the decision of the developers to separate MySQL logging in this way is very wise and convenient.
Firstly, it allows you to unload the server from writing logs that are unnecessary in most cases (therefore, in fact, request logs are not written by default). And, secondly, writing logs to separate files allows you to sort the information stored in them according to their purpose.
I showed you how to view MySQL logs through the OpenServer interface. However, personally, from time to time I come across in practice such cases when the log is very large, and it is necessary to find a specific entry in it.
Then the OpenServer log viewer becomes useless, because it does not provide any search tools, and you need to look through all the records in searches - the occupation is very long and unpromising.
Therefore, in this case, I prefer to open the log files with a regular text editor and perform all the necessary operations there.
OpenServer log files, including MySQL, are located in the directory openserver_install_dir/userdata/logs which in my case looks like this:
In the screenshot, I marked the log files of my current version of MySQL: the state of the server and requests to it. All other logs maintained by OpenServer are also available here.
As you can see, log files are written separately for each version of MySQL and other server components used, as I discussed in the previous section on changing the current version of MySQL.
Setting up MySQL in OpenServer
We talked about choosing the required MySQL version for working and logging in OpenServer. Another point that is quite common in practice is the need to configure MySQL in OpenServer for correct operation and the functions it performs on certain projects.
MySQL setup consists in adding/removing and changing existing configuration parameters contained in special files - configs.
To get access to MySQL configs, just launch the familiar OpenServer management menu, select the item Additionally and select from the dropdown list Configuration.
After that, another menu will appear, which will contain shortcuts to access the configuration files of the current OpenServer modules selected on the tab Setting where we changed MySQL version:
When you select the MySQL config shortcut, the corresponding file will open in the text editor installed on your PC as the main one.
If you need access to the MySQL configuration file itself, you can find it in the directory install_directory_openserver/userdata/config, in which the configs of all OpenServer modules are located, moreover, for each version of the component, the config is separate.
When working with configs of server components, it should be borne in mind that in order to reduce their text and ease of use, there are special OpenServer variables in their text, the full list and values of which you can find here - https://ospanel.io/docs/#rabota-s -path
And also keep in mind that after any changes in the MySQL settings files in OpenServer, for them to take effect, you will need to restart the server after saving the file.
Tools for working with MySQL in OpenServer
We talked about the choice of MySQL versions in OpenServer and their configuration. Now is the time to move on to working with databases, users, and other objects created on the MySQL server.
And for this, OpenServer has a whole set of tools with a graphical interface. Therefore, if you are not a hard coder, but nevertheless you need to create a MySQL database in OpenServer or change the user password, then using graphical editors is the easiest and easiest way to do what you have planned.
Well, nobody canceled the OpenServer console for working with the MySQL command line.
The visual tools are represented by various utilities that can be accessed from the OpenServer menu by selecting the Additional:
In the screenshot above, I highlighted the utilities for working with MySQL, which are included in OpenServer by default.
The first two are intended exclusively for working with MySQL databases, and the last one is universal (you can work through it in various DBMS).
Therefore, when you disable the use of the MySQL module in OpenServer, phpMyAdmin and MySQL manager will disappear from this list altogether, and the SQLite manager will remain, but it will be impossible to work with the MySQL server through it.
Let's take a brief look at each tool and the features of working with it in OpenServer.
phpMyAdmin
A familiar utility written in PHP for administering exclusively MySQL servers, which is preferred by both beginners and professionals. Provides a visual interface for working with the MySQL server, through which it is very easy to manage databases, users and their rights.
When launched from the OpenServer menu, phpMyAdmin will run either in an open window of your browser or in a separate window.
To be honest, I find it difficult to answer what it depends on. On one PC, phpMyAdmin from the OpenServer kit runs in an open window, and on the other, in a separate one.
After a successful launch, phpMyAdmin will look like this:
This is the start screen where you need to enter your MySQL username and password to connect to the server. By default (if someone is not in the know) admin account root/blank_password.
Enter, enter, work 🙂
I will not give a complete list of phpMyAdmin features now, because. for this there are specialized publications and video tutorials, which are already full on the Internet. If you are completely new, you can use the following video as a starting point:
Regarding the peculiarities of working with phpMyAdmin in OpenServer, I can note the possible occurrence of the following error, which I encountered when switching MySQL versions:
SQL query error: SET lc_messages = "ru_RU"; MySQL response: #1193 - Unknown system variable "lc_messages"
The reason for its occurrence was the choice of MySQL version 5.1, in which, as it turned out after studying articles on the Internet, there is no system variable lc_messages, which phpMyAdmin is trying to install.
It appeared in MySQL 5.5, upon installation of which, in theory, the problem should have disappeared ... However, nothing of the kind, to my great surprise, did not happen 🙂
After changing the MySQL version and restarting the server, the error continued to irritate with its presence.
The reason turned out to be in the banal browser cache, when cleared, phpMyAdmin started working normally.
phpMyAdmin is a handy thing for working with a local MySQL server.
However, sometimes there are situations when you need to connect to different MySQL servers, it is either difficult or impossible to install specialized software (for example, in companies with high requirements for network and information security).
Fortunately, for such cases, the OpenServer package has other tools for working with various MySQL servers.
MySQL manager
When selecting the menu item OpenServer MySQL manager the HeidiSQL program is launched, with a detailed description of which you can see here - https://www.heidisql.com/
I don’t know why it was renamed, apparently, for a simplified understanding of users what awaits them after launch 🙂
I myself actively use this utility at my main job, so as not to install various additional software. You can run it from the same OpenServer menu item as phpMyAdmin.
Running HeidiSQL is slightly different from phpMyAdmin in that it is a desktop program and not a web application, so it will always open in a separate window.
After starting, you will see on the screen a form for connecting to the MySQL server, which looks like this:
To demonstrate the possibilities, I made a test connection to a local MySQL server, after selecting which this window will open:
It is already, in fact, an admin panel for working with the MySQL server, in which you can manage databases, their tables, indexes, triggers and other entities.
For example, in the screenshot above, I created a test database and opened the menu for managing it, where I chose to create a table.
In principle, it is quite convenient. Many people may like it even more than the usual phpMyAdmin - this is already a matter of taste 🙂
But personally, I use the MySQL manager OpenServer only for remote connections. With a local server, I still prefer the first option.
SQLite manager
Another graphical client for working with MySQL in OpenServer. Under this name, as in the previous case, there is a utility with a completely different name - Adminer, a detailed description of which can be found here - https://www.adminer.org.
Perhaps, to the old-timers of the Internet, this utility will be familiar by the name phpMinAdmin 🙂
The creators of OpenServer decided to rename it to the SQLite manager, most likely from the considerations that this utility is the only one from the entire OpenServer suite that allows you to work with the SQLite DBMS, which is still in some demand in narrow circles.
The launch of this utility is very similar to phpMyAdmin and just as unpredictable: it can open either in an open browser window or be in a separate one.
On the screen, you will first see a connection form that looks like this:
This form immediately shows the great advantage of Adminer over phpMyAdmin, because it allows you to connect not only to the local MySQL server, but also to remote ones, and it also supports work not only with MySQL, but also with other DBMS, including:
- PostgreSQL
- SQLite
- MS SQL
- Oracle
- firebird
- SimpleDB
- elasticsearch
- MongoDB
The list is very solid, I must say 🙂 In addition to these advantages, this program also has the ability to easily and simply change skins that are decorated with ordinary CSS files, therefore, anyone who has at least a little knowledge of this language can edit them.
This is what the MySQL server control panel looks like in Adminer after connecting to it using the default skin:
Yes, I agree, it looks rustic, but it also works faster than phpMyAdmin, with which the creators of the ex-phpMinAdmin are very fond of comparing their work. But again, this is at the default settings.
As I already said, all this is solved by changing skins.
Working with MySQL in the OpenServer Console
We have reviewed the tools that provide a graphical interface for working with MySQL, and which are included in the OpenServer package.
However, there are times when their use is not entirely convenient.
First, let's figure out what OpenServer is and why it is needed at all. OpenServer is a program, or rather a local server, with which you can create or edit websites on your computer and then upload ready-made or modified ones to the hosting. That is, if you are going to create your first website, then for a start it is not necessary to buy a domain and hosting, in this program you can create websites as much as you like and do various experiments for free!
With it, it is very convenient to make changes on your site without affecting the working version, because the files will be located on your PC, and not on the hosting, because if you start to change something on your working version on the hosting, then you can simply push your audience, because at the moment when you make changes, they will not be able to understand what is happening with your site and most likely will leave it, because it often happens that the site sometimes stops working while making changes. The first time I did it myself until I found out about this method.
So, first you need to download this program on the official website, on the download page, select the maximum version of "Ultimate" as it has more features, free download is currently at a low speed, at maximum speed it will be available to you if you make a donation , I contributed 100 rubles to the author (as a token of gratitude) and downloaded at the maximum speed available for myself.
After you download and install the program, I want to show you one important detail, go to the "OpenServer" folder
it will contain 4 folders, we are interested in the “domains” folder, it is in it that our sites are stored
like in my example
that is, first you need to create a folder with the name of the site, for example test.local
ending after the name of the site local - required! Otherwise, there may be problems with the operation of the site on a local server, then we drop the installation files of the engine (wordpress, joomla, drupal, etc.) into this folder, I will show you the css of the wordpress engine as an example.
In our case, you need to go to the official website and download the engine itself
as soon as we downloaded the archive, we need to unzip it, after unzipping we will have a folder with files, we need to transfer these files to the test.local folder, or you can transfer the folder itself and rename it to test.local.
Now we need to install this engine, we need to run this program by clicking on the green label of the corresponding bit depth of your OS, I have 64-bit, so I'm running "Open Server x64"
I advise you to immediately take out the “OpenServer” folder itself so that it is immediately in front of your nose)). A red flag will appear at the bottom, this indicates that the program has started, but in order for it to function, you need to select the green flag and click start, after launch we will have a list of sites in the “my sites” section that are in the “domains” folder. Before installing the site, we definitely need to create a database, for this we go to the “OpenServer” profile and select “Advanced > PhpMyAdmin” in the menu that opens, then we will open a separate browser window (which is set by default in your system, in my case it is Google Chrome) it will open the authorization window
it is not necessary to enter a password here, the most important thing is that it be root in the “user” column (sometimes there are cases when login is not performed without a password, then we also write root in the password column).
Once you are logged into the PhpMyAdmin control panel, we need to click "Users" at the top
at the bottom you need to find the word "add user"
here we will be creating a new database for our website. Here we write the name of the database, it is desirable that it matches the name of the site without a domain, come up with a password and check the box below "Create a database with the same name and grant all privileges to it."
Once we have created a database, we can start installing our engine, you can read about how to install wordpress in this article.
That's all, in this article I tried to tell as much as possible from my personal experience about the work of OpenServer. If you still have questions, write in the comments, I will help everyone.