Database Reference
In-Depth Information
Not having a password for the root user can be dangerous! If you did
not set one during the installation, be sure to set one immediately after
the install following the instructions in Chapter 3 , MariaDB Security .
If MariaDB has been successfully installed and started, we should see something
similar to the following screenshot when connecting using the previous command
to launch the mysql command-line client:
If you get the MariaDB command-line prompt as illustrated in the preceding
screenshot, congratulations! You've just installed MariaDB and can successfully
connect to the server using the command-line client. You can quit the command-line
client for now. Don't worry; we'll come back to it soon.
Troubleshooting installation issues
The MariaDB installers work very well. And they are tested and retested constantly.
Occasionally issues with either installing MariaDB or running it for the first time are
discovered, but they are almost always fixed promptly so that users are not affected.
If we do happen to run into an issue when trying to start MariaDB, what should
we do?
The first thing we should do is look in the error log. The MariaDB error log is either
stored with the system logfiles (for example, under /var/log/ on Linux) or in the
MariaDB data directory. Common locations for the MariaDB data directory include
/var/lib/mysql/ on Linux, C:\Program Files\MariaDB <version>\data\ on
Windows ( <version> is the version number of MariaDB we are using), and /usr/
local/var/mysql/ on Mac OS X. The error logfile itself will either be called mysql.
err or hostname.err where hostname is the name we've given our computer. It is
also worth noting that the name and location of the logfile can be customized by the
my.cnf or my.ini file. The next chapter on configuring MariaDB will go into this file
and its location.
 
Search WWH ::




Custom Search