![]() I discourage use of Fedora and any version of Ubuntu that isn't LTS, because their lifecycle is way too short for a server. We also have a few users getting great use out of Solaris (the Joyent folks, for example, use Solaris on all of their boxes) and FreeBSD. And, in this case, the crowd is very clearly using CentOS 5. They are all fine operating systems.but, if you don't know a lot about what you're doing, you should just do what the crowd is doing. I have CentOS 4 and 5 on all of our servers, Jamie runs Ubuntu on a couple of his machines, and I run Fedora 9 on my desktop, Debian 4.0 on my devel server, and Ubuntu on my laptop. We can't fix what we don't know about.Īnyway, we like them all. For folks who love Debian or Ubuntu, and want things to get better, you'll need to file bugs about problems you run into. We just get far fewer useful bug reports about Debian and Ubuntu installs than CentOS, so it just doesn't get the same amount of attention. Debian is second.so it has been better tested than Ubuntu 8.04, and so on. The reason for this order is because CentOS 5 has (at least) ten times the number of Virtualmin users using it, so it gets a huge amount more testing. On another thread Joe recommended using of Debian but maybe you are right. Particularly the Mailman and MySQL unavailable thing, as those are actual bugs. I'll do a test install on Debian this afternoon and see if any of these problems present for me. So, I see that this one seems to have magically resolved itself (it wasn't the installation of php-mysql that fixed it, but you're reporting it fixed, so something fixed it!). )ħ) Checked MySQL: No connection to MySQL server. I don't understand what more you want me to tell you about it. But, it tells you exactly what to do to fix it. So, this should have been done automatically, which is a bug in the installer-filing a bug in the tracker about it will get it fixed. What should we do to make that more clear?Ĥ) Click 'Create Virtual Server': Error message: 'Failed to create virtual server : Mailman cannot be enabled unless the administration list mailman has been created.This can be done in the Mailman plugin module.' And we can't (safely) leave it unset, because that would allow local users to access MySQL as root. We can't set it for you automatically during installation because we don't know what you want the root MySQL password to be. (Or you can set it from the command line.) You can do that in the Webmin MySQL module. You need to set a root password for MySQL. GPL License information.2) Click the 'Re-check and Refresh Configuration' button: It tells me to set a root password for MySQL: Root password for MySQL set. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 54 languages. PhpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Sudo mysqladmin -h -u root -p password your-new-password Sudo mysqladmin -u root password your-new-password The local-machine-name is the name of the computer you’re working on. So that the local computer gets root access as well, you’ll need to set a password for that too. MySQL comes with no root password as default. You can check your configuration using the following command Open the file /etc/mysql/my.cnfįind the line bind-address = 127.0.0.1 and comment it out We’ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Click on the Module Config link, and in the System Configuration section enter the IP address of the system you setup in. MySQL initially only allows connections from the localhost (127.0.0.1). Now that MySQL is running on a separate system and can be accessed remotely, you can configure Webmin (and thus Virtualmin) to use it as follows : Login to Virtualmin, and go to Webmin Servers MySQL Database Server. This will complete the installation of mysql server 5.0.45 in ubuntu gutsy. Sudo aptitude install mysql-server mysql-client libmysqlclient15-dev It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. MySQL is a widely used and fast SQL database server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |