Tag Info

New answers tagged

0

Open up your terminal or console and type the following: mysql -u username -h x.xx.xx.x -p then enter your password This gives you the assurance that the connection from your host it works, and if not, return a useful error output.


0

How are you connecting to the database, if it is with php try mysql_connect("localhost", username, password); with localhost as your host.


0

Make sure that you have run sudo apt-get update before running sudo apt-get install php5 libapache2-mod-php5 php5-mysql because it will update the package lists so that the latest software can be installed.


1

I think I may have figured out the issue - It has to do with the long password.I think that this should reported as a bug to MySQl and MariaDB developers because on installation you can create a password with over 100 characters but when you try to login to MySQl or MariaDB when it is in production you get the above error. So glad I figured this out after ...


0

It should just be a matter of: sudo apt-get install mysql-server Follow the prompts to enter a root password during installation. Then connect: mysql -u root -p Enter the password set during installation.


0

You could probably use knockd to do it if you really wanted to. I also have quite a few daemons installed for various uses, and I tend to just disable them starting on bootup and manually start them when I need them. The command to do so would be: sudo update-rc.d $serviceName disable and then the obvious sudo service $serviceName start when you ...


0

Try this command in terminal: mysqladmin -u root -pcurrentpassword password 'newpassword' Then, type: mysql -u root -pnewpassword


0

That saved my day! Clear steps. http://www.randomhacks.co.uk/mysql-job-failed-to-start-unable-to-set-root-password-cant-find-file-mysql/


0

There are a couple of steps to check when you do it manually that could create the error mentioned above. I will assume you either manually downloaded MySQL from the official site or used a 3rd party PPA to install it: Check that mysql is not already running: ps -e|grep -i 'mysqld'. If it appears then you need to kill it by doing a sudo killall -9 ...


0

You should: Add a user for your mysql server useradd -r -s /bin/false -m -d /mysql mysql Write an upstart script for your server. Check that the pid file and socket files can be created by your mysql user by executing the proper chmod's.


1

You have elected not to install the mysql package provided by Ubuntu and have instead manually installed a version into /usr/local - as such you are not doing things the normal "Ubuntu" way and the advice you get here may be affected. The normal way of install MySQL in Ubuntu is by installing the package provided by Ubuntu using something like sudo apt-get ...


-2

try the following: quit; this worked for me...then i just got the msg: "bye". then it was showing again to enter a comand as the USER@user>, not as MYSQL>. Help this works!


0

let drop it, then in the phpmyadmin config.inc.php you can increase the time out from 300sec to infinity add this line $cfg['ExecTimeLimit'] = 0; and: php> php.ini Find: post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60 memory_limit = 8M Change to: post_max_size = 750M upload_max_filesize = 750M ...


0

You must enable listen on port 8081 for apache. sudo nano /etc/apache2/ports.conf add Listen 8081 Restart apache


0

For Ruby on Rails see this instruction and for mysql run command sudo apt-get install mysql-server


0

mysql-server and mysql-client are often virtual packages that depend on a more version-specific mysql package, like mysql-server-5.5 and mysql-client-5.5. You can check for what MySQL packages are still installed using the following command: dpkg --get-selections | grep -v deinstall | grep "^mysql" Then you can use this list to apt-get remove whichever ...


0

Would you check out your mysql really running? Please try ps auxw|grep mysql I have some test like below, I could get same error when i shut down mysql server. root@ubuntuz:~# ps auxw|grep mysql mysql 1361 0.2 1.2 326532 11340 ? Ssl Feb19 162:34 /usr/sbin/mysq d root 24553 0.0 0.0 5576 800 pts/0 S+ 08:43 0:00 grep ...


1

The error does not mean that you still have MYSQL server running. In fact, if the client can not connect to it, probably you don't have it running. You still have the client available for execution: mysql You can find out the package where mysql is, with: dpkg -S `which mysql` Then remove it, if you really want to do that.


1

Since MySQL 5.1.X is only available in the repositories for 10.04 (Not 12.04), I started searching for others with the same issue. Found a script in github (Thanks kamermans) Which shows the following: #!/bin/bash set -e cd ~/ wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.65.tar.gz tar -zxf mysql-5.1.65.tar.gz cd mysql-5.1.65 ./configure ...


1

At some point in time, your disk ran out of space, and some space was allocated by mounting a virtual disk called "overflow" at /tmp. Now MySQL tries to create a file in /tmp but it can't. To remedy this, dosudo umount overflow I got this idea from here.


2

mysqldump is the general method to copy a database over. Create a dump on windows: mysqldump -u [USER] -p [DATABASE] > [BACKUP] Copy the file over to Ubuntu and restore it in Ubuntu: mysql -u [USER] -p [DATABASE] <./[BACKUP] both commands are done from the shell (not from within MySQL).


1

There are many packages that are just metapackages (a package that only depends on another package(s)). mysql-server is one of them. To actually remove the main MySQL Server, use sudo apt-get --purge remove mysql-server-5.5. However, that command doesn't remove the dependencies pulled in by that package. Sometimes, doing a sudo apt-get autoremove gets rid ...


0

The solution I found is to add a custom PPA and install phpmyadmin with mysqlnd without any problem like this: sudo add-apt-repository ppa:nijel/phpmyadmin sudo apt-get update sudo apt-get install php5-mysqlnd sudo apt-get remove phpmyadmin --purge sudo apt-get install phpmyadmin


1

Without a package manager you can download source code. At the website you posted choose "Source Code" and then take the generic one: "Generic Linux (Architecture Independent), Compressed TAR Archive". Now you have to compile the source code. There are plenty of guides how to compile mysql manually. Another option would be to download the Debian package ...


2

According to the log, there is an error with a variable : unknown variable 'default-character-set=utf8' default-character-set is a variable used for the client and not for the server. I suspect that in your /etc/mysql/my.cnf file, there is a line default-character-set=utf8 in the section [mysqld] instead of the section [mysql] or [client]. If you ...


-1

According to this, you need to change the line default-character-set=uf8 in the file /etc/my.cnf to: character-set-system=utf8 and try again to start the server.


0

Run this command: sudo dpkg-reconfigure mysql-server-5.5 (5.5 is the version number, adapt if you have a different version) This will allow you to set your MySQL root password, that you can then use with mysqladmin and mysql commands.


1

It sounds like you don't have the right permissions on /tmp, which should be world writable. You should be able to fix it with this command: sudo chmod 1777 /tmp That will set the permissions to 777 (rwx for everyone) and also set the sticky bit which is recommended for the /tmp dir. As explained in man chmod: RESTRICTED DELETION FLAG OR STICKY BIT ...


0

Problem solved. The cron job was running each night but not completing. The problem was with the script. The cron shell did not interpret "==" as equal, i.e. in the cron shell "1==1" was evaluated as false. However, when I ran the program at the command line it worked. I read somewhere that the bash shell understands == or = to mean equal... but the ...


1

You have to use sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql instead of install mysql-server libapache2-mod-auth-mysql php5-mysql install is a different command that doesn't install software packages.


0

I got this error after installing tt-rss with all the default settings (connecting to the database using unix socket, with "ident" identification). I was able to fix it by doing the following: sudo dpkg-reconfigure tt-rss During the ncurses install process I selected tcp-ip as the connection method rather than socket and specified "localhost" as the ...


0

My money's on Benoit for having the truly correct answer here, but as soon as you can verify that your script executes you will likely find some additional errors. In short, make sure you also check your environment! You're half way there by using variables that define the location of the commands (MYSQL="$(which mysql)") but which mysql just reads your ...


0

Ensure to run: sudo crontab -e (or crontab -e as root) And add the desired script: */15 * * * * /bin/bash /home/wayne/scripts/mysql_backup.sh This will initiate the cron every 15 minutes, obviously you may want to change that.


1

Unless you've skipped some characters when writting the syslog output in your question, it looks like you've made a typo in your CRON command by forgetting the / in front of the command that should looks like : /home/wayne/scripts/mysql_backup.sh


1

Ubuntu 12.04 comes with a OpenSSL 1.0.1, which has somewhat different defaults than the older OpenSSL 0.9.8 version. Among other things, if you're using openssl req -newkey rsa:2048 to generate an RSA key, you'll end up with a key in a format called PKCS #8. Represented in the PEM format, these keys have the more generic -----BEGIN PRIVATE KEY----- header, ...


1

WAMP is an acronym that stands for Windows Apache MySQL PHP. It is also often referred to as web-stack because the each part "stacks" on top of the previous one to create a complete system. The linux equivalent is a LAMP stack (yes, you guessed right! it stands for Linux Apache MySQL PHP). A good practice is to install the stack on a virtual machine (if ...


0

Way dont u tray xampp server its and alternetive for wamp its a cross paltform also available for linux. U may download from here:- http://www.apachefriends.org/download.html


2

Since mysql-utilities is not available from the 12.04 repo, you'll have to install the quantal version instead Download this deb file Install python-mysql.connector: sudo apt-get install python-mysql.connector Run sudo dpkg -i mysql-utilities_1.0.5-1_all.deb


0

AllowOverwrite for /var/www should be None in stead of All ;)



Top 50 recent answers are included