Tag Info

New answers tagged

1

You are using ln -s with the arguments the wrong way round. Think cp when you use ln: the source comes first, the destination last. You want to have a link /var/lib/mysql pointing to actual directory /home/databasesmysql. If you were copying you would do: cp -r /home/databasesmysql /var/lib/mysql So with ln -s you do: ln -s /home/databasesmysql ...


0

Did the directory /home/databasesmysql exist before running the commands? If it did, the directory /var/lib/mysql was not copied to /home/databasesmysql, it was copied into /home/databasesmysql, so the copy is named /home/databasesmysql/mysql, instead of /home/databasesmysql. That would mean the link /var/lib/mysql does not point to the right directory, ...


0

I would like to thank Salem who was very helpful in suggesting me various solutions for my problem. But unfortunately I was unable to resolve my issue. And as I had very important data which I did not want to loose data. This is my first time and have tried to write down all the points as much as I could remember below: 1. Created a copy of ...


0

Aha, I fixed it. Turns out dovecot had messed something up and "auth-sql.conf.ext" was not the right file. I simply swapped it for the proper one (obtained off of github https://github.com/bdraco/dovecot/blob/master/doc/example-config/conf.d/auth-sql.conf.ext) and dovecot started with a hitch. Very odd indeed.


0

Are any of those commands actually interactive? If no, just use exec if {[file exists "/usr/local/sbin/remoteTasks/restartMySQL"]} { ## STOP APACHE FIRST exec apache2ctl stop exec service mysql restart file delete /usr/local/sbin/remoteTasks/restartMySQL exec apache2ctl start } if {[file exists ...


1

Could anyone please comment what I have missed during Ubuntu setup, that I am allowed to nothing on my system? You wont be able to edit my.cnf because its protected by its permissions from regular users writing to it. You could change the permissions or the group of the file but this really isn't necessary and could compromise security. Like you have ...


0

According to cron manual: When executing commands, any output is mailed to the owner of the crontab (or to the user named in the MAILTO environment variable in the crontab, if such exists) So you should use this command in order to modify crontab configuration file: crontab -e This will open /etc/crontab file and, according to crontab manual: ...


1

I have encounter the same problem when I init my small VPS. The issue is caused by small memory. So without spending extra money to increase the memory which you not needed, you could simply create swap files to aids the installation. Yes the swap is slow, but all you need is get the install done. On Ubuntu 14.04, I do the following to solve the problem: ...


1

To show errors in PHP, edit your php.ini file and change: display_errors = on Restart your apache server. Then in your project config.php file (if you have one), add these lines: /* errors handling */ error_reporting(E_ALL); ini_set("display_errors",1); ini_set('log_errors',0); ini_set('error_log','path/to/log/file'); During development, set ...


2

You can do it in 2 ways, by editing the php.ini file or using .htaccess If you edit the php.ini file which is located in /etc/php5/apache2/php.ini Find the value that says upload_max_filesize and change it to the value you wish, for example here I have a max upload file size of 100M upload_max_filesize = 100M Now you also need to edit the post_max_size ...


0

Welcome To The World Of Linux First of all, Please try to reinstall your os to the latest versionif possible as there are plenty of patches updated. This may be the cause to your problem. Next, update the current os with all the packages. Media/ Codecs sudo apt-get install ubuntu-restricted-extras After following the above steps, try following the ...


0

For those using Windows with the Workbench 6.1, here's how I found to make this work. Select your schema and in the query box, enter: set global max_allowed_packet = 1073741824. You can use a lower number, but it must be a multiple of 1024. This is the largest value allowed (1 gig). Once you do this, SHOW VARIABLES doesn't show the change :(, but ...


0

Follow the below steps...So that you can easily remove mysql.I use these methods for removing mysql completely. sudo service mysql stop #or mysqld sudo killall -9 mysql sudo killall -9 mysqld sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo deluser mysql sudo rm -rf /var/lib/mysql sudo ...


0

It is possible to have both MySQL servers running on the same machine but, it'll take some work. First you would need to install 5.7 in a different directory than 5.5. Also since MySQL uses a default port, you would need to run 5.7 on a different port. You're basically creating an entire new MySQL server update-alternatives is a program that could work ...


1

There are problems here in attempting to do what you are asking and keeping your package manager happy. Off the top, I see two choices here: compile/install from scratch to an entirely different directory hierarchy If I recall, there is a way to install packages using a different base root directory. Do that and then manually make the necessary changes. ...


0

Disabling the performance_schema also saves a lot of memory. My empty database going from 400m to 40m on startup: performance_schema=0 MySQL Docs: http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html


0

Try this to set back the permission: sudo chown mysql:mysql /var/lib/mysql You can check if the mysql user is available on your system with the command: id mysql it should response something like this: uid=107(mysql) gid=111(mysql) groups=111(mysql)


0

The username is probably mysql, not "MySQL Server" or "MySQL". Remember, everything in Linux is case sensitive. You can also find out the exact username by running grep -i mysql /etc/passwd and take a look at the first word, that's the username.


0

The error is in the log: Fatal error: cannot allocate memory for the buffer pool As a quick solution you have here 2 options: add more RAM to the server, or decrease the value of innodb-buffer-pool size in the config file: innodb_buffer_pool_size = 10M


1

User names are actaully just mappings to UIDs stored in /etc/passwd. Similarly group names are mapped to GIDs from /etc/group. The IDs are decided as and when they are required. 0 is always root but almost everything else is decided when the user and groups are created. These *IDs are near-arbitrary integers that the system interprets as defined users and ...


1

use the command sudo nano /etc/mysql/my.cnf and change the bind address to your local host or 127.0.0.1 then save and close the my.cnf window. Then run the below command sudo service mysql start then try login mysql -u root -p


0

Your "locales" have not been generated yet, or not properly. Try this: sudo locale-gen en_US en_US.UTF-8 pl_PL pl_PL.UTF-8 sudo dpkg-reconfigure locales Then try again to install MySQL.


1

You can relax. There is in general no notion of "conflict" between distinct web (and SQL) servers running on different machines - given, of course, that they aren't configured to share the same IP address, which would be a problem in general. All you have to do is, of course, to make sure you use the correct IP address or hostname for the machine you want ...


1

You could download directly the lib by pulling the git repository: https://github.com/zendframework/zf2 PS: Don't download from the master branch, choose a tag. Or, if you know how to use composer, a PHP package manager, thats an option too. You could learn by reading the guides in the official web site: http://framework.zend.com/learn/ More download ...


0

My answer: PowerDNS It's built on top of MySQL by default and is much less difficult to set up. +1!


2

Assuming you have created a database named servermail, now the guide says that you must create a user named usermail with password mailpassword. The names can change to whatever you like, just keep consistent naming. The usermail user must be created inside MySQL shell. He is not related to system's users. If you follow the guide and type: GRANT SELECT ...


1

Found the answer and maybe it's useful to somebody else. The thing is that, even after uninstalling the mysql server in order to install it again and try it over, the system didn't allow me to create a password. So I did uninstall it using sudo apt-get remove mysql-server and after that sudo apt-get autoremove, but that wasn't enough. The error was still ...


0

If the Problem still occurs, enable the module by adding: extension=mcrypt.so to /etc/php5/cli/php.ini and /etc/php5/apache2/php.ini


0

The solution copy from link If you have your own Ubuntu server running you may encounter the maximal file size upload limit in php scripts which is set to 2Mb as default. In order to change that we first have a look what the size actually is. In /var/www (standard www directory) create a file called info.php with the following content: Then browse to this ...


1

Open the terminal and type: dpkg --get-selections *php* This will list all the php packages that are currently installed on your system through apt-get.



Top 50 recent answers are included