Tag Info

New answers tagged

3

Fixed by creating /etc/my.cnf prior to installing MySQL only containing [mysqld] innodb_use_native_aio = 0 Source


0

Try this sudo apt-get clean sudo apt-get update sudo apt-get install -f sudo dpkg-recofigure -a


0

To solve your problem, don't use deb files, if the packages can be installed via package manager and don't use debian repositories for no reason. I assume, you have downloaded the deb from here or a similar side or you have added the line deb http://ftp.debian.org/debian/ wheezy-proposed-updates main to your sources.list. Remove this repository and start ...


0

All the compiler options, include and library paths, and library directives required to build a simple mysql client should be provided by the mysql_config utility. In particular, nothing in /var/lib/mysql should be required. Unfortunately AFAIK Eclipse CDT does not currently support direct command substitution within the IDE. (IIRC it now supports ...


0

Another way to do this is to convert the records into SQL queries and to import the SQL queries into the database (as you would with an SQL dump) all at once. This awk command just converts the records into SQL queries: awk '/ [0-9]+/ {print "INSERT INTO bar (field1, field2) VALUES (\""$3"\", \""$4"\");"}' inputfile user@debian:~$ awk '/ [0-9]+/ {print ...


0

You might also want to look at setting up a VirtualBox environment for PHP development. This way you keep your host OS free from server packages but you can still do all development on your own PC with the shared folder functionality. :)


1

1. Installing and setting up the LAMP stack Open Terminal by hitting Ctrl+Alt+T Update the apt cache and install lamp-server^ by running sudo apt-get update && sudo apt-get install lamp-server^ (you should be able to go through the on-screen setup; it's just a matter of setting up the mysql root password) 2. Installing and setting up PHPMyAdmin ...


1

To install these packages in the command-line you can type sudo apt-get install lamp-server^ phpmyadmin There is also extensive documentation how to set up a LAMP environment with phpmyadmin at https://help.ubuntu.com/community/ApacheMySQLPHP | https://help.ubuntu.com/14.04/serverguide/lamp-applications.html Feel free to ask more specific questions if ...


0

Run those commands: sudo apt-get update Install apache: sudo apt-get install apache2 You can test apache2 is working by directing your browser to http://localhost , you should see "it works" output. Install PHP: sudo apt-get install php5 libapache2-mod-php5 Restart apache2 now: sudo service apache2 restart To test PHP now create a file ...


0

You can use this sed filter to convert your text table into json objects: cat your_text_file | \ sed -e "s/.*\(fr-\w*\)\s*\([0-9A-F:]*\).*/{"user":\"\1\",\"mac\":\"\2\"},/g" You will get objects like this: {user:"fr-65111111","mac":"F0:24:75:33:22:11"}, {user:"fr-x0584444","mac":"50:32:75:33:22:11"}, {user:"fr-AA055555","mac":"3C:AB:8E:33:22:11"}, ...


0

This is now under /etc/apache2/conf-available/security.conf which is then symlinked by a2enconf to /etc/apache2/conf-enabled/security.conf


0

Different solution for those still having issues. Hopefully I can help those trying to reinstall Mysql. Note, It's a seek and destroy mission. So be weary. Assuming your root: apt-get purge mysql* apt-get purge dbconfig-common #the screen used for mysql password find / -name *mysql* #delete any traces of mysql #insert apt-get cleanups, ...


0

on username input field, put a javascript function and then use ajax to call server side code and then append result of that as option with url field. like following. <form name="login" action="index_submit" method="get" accept-charset="utf-8"> <ul> <li> <label for="seller">Seller Name/ID</label> ...


0

The problem was that the /etc/mysql/my.cnf was writable by another user than 'root'. So during the installation of mysql, the file was ignored and the installation didn't worked well. A simple : chmod 644 /etc/mysql/my.cnf aptitude remove mysql-server aptitude install mysql-server aptitude install mysql-common Did the job very well after all. Aptitude ...


0

You could check first which program is using port 80 (default http port) with : sudo netstat -tulpn | grep :80 And you will get something like tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 1547/nginx For me is nginx, but it could also be apache2, lighttpd, or any other. Next step is to now if it's running as service, which is an option in ...


0

I tried to startup mysql in "Safe Mode" to create the sock file and pid file, but it fails for some error "bind", I changed the IP address in "bind ip" parameter in my.cnf to localhost started mysql in safe mode. restarted mysql in normal mode, and everything went fine.


0

Clean your os from all mysql install and add ppa from there https://launchpad.net/~ondrej/+archive/ubuntu/mysql-5.6


0

As per comments: xampp is complaining that you changed the config file and made its permissions 777. (world readable and writeable) Remove it and install the Ubuntu native LAMP stack with: sudo apt-get install lamp-server Less hassle, more secure and made to work out of the box.


0

Try service mysql restart. Ubuntu uses upstart for mysql service (see What's the difference between "Service" and "/etc/init.d/"?), and it's behavior differs from init scripts. What version of Ubuntu and Mysql are you using? Could you please post above command output and /var/log/mysql*?


1

a simple hack: sudo ln -s /var/run/mysql/mysql.sock /tmp/mysql.sock sudo service mysqld restart If this doesn't work then try this: First find open socket files for mysql in your system sudo find / -type s 2>/dev/null | grep mysql For my case it's /var/lib/mysql/mysql.sock Then edit the configuration file /etc/my.cnf sudo gedit ...


1

I've developed some steps to install php 5.3 + Apache on Ubuntu 14. First, write the following repositories to the file /etc/apt/sources.list.d/ubuntu-old.list deb http://55.archive.ubuntu.com/ubuntu/ trusty main deb http://security.ubuntu.com/ubuntu precise-security main universe deb http://cz.archive.ubuntu.com/ubuntu precise main universe run apt-get ...


1

Because you don't give us anymore information … All packages are in the Precise repositories: php5gd php5-mcrypt You could install the packages separately: sudo apt-get install php5-mcrypt sudo apt-get install phpmyadmin and maybe (because recommended) sudo apt-get install php5-gd


0

Set a password for mysql sudo dpkg-reconfigure mysql-server-5.x Now open the terminal and type mysql -uroot -p give password and press enter


0

Enter this command ad your mysql start automatically: sudo update-rc.d mysql defaults


0

Remove PHPMyAdmin sudo apt-get purge phpmyadmin sudo apt-get autoremove sudo apt-get clean Reinstall it sudo apt-get install phpmyadmin


1

Just luck that I saw your question. This happened about 2 weeks ago to a friend at work. Since I saw the version was 14.10, I suggested to upgrade to 15.04 and then we could proceed on figuring out what was wrong. After upgrading, his issues with Workbench were gone. So there might be a couple of things that could be causing this: Version of the Libraries ...


0

Yes, I think moving to 14.04 is the best option. I am using Mysql workbench without a problem. I think you better to download software package directly from official site, and go to downloaded location and open with software center.


1

This is so easy. Using it in Ubuntu 14.04 LTS and it's working without a hitch: Create a new file via terminal by running the command below gedit ~/.local/share/applications/lamp.desktop Copy and paste this text inside [Desktop Entry] Name=LAMP GenericName=LAMP X-GNOME-FullName=LAMP Comment=Open services of your LAMP server Exec=gksu service apache2 ...


3

You can check the datadir in the various configuration files: grep datadir /etc/mysql/my.cnf grep datadir /etc/mysql/mysql.conf.d/mysqld.cnf grep datadir /etc/mysql/conf.d/mysql.cnf grep datadir ~/.my.cnf By priority: ~/.my.cnf /etc/mysql/mysql.conf.d/mysqld.cnf With these lines in /etc/mysql/my.cnf !includedir /etc/mysql/conf.d/ !includedir ...


3

There should be files named mysql at least at these locations /etc/mysql/ /etc/init.d/ You can check if there is a running mysql with... ps -ef |grep mysql Or type mysql on command line. It will show an error if there is a mysql: ERROR 1045 (28000): Access denied for user 'xxxx'@'localhost' (using password: NO) If there is no mysql in /etc/ you do ...


0

This is the serious bug from debian and is actually due to the files libgcc1 and libc6 in turn it affected the python3 which was the backbone for most of the applications. Even you install the mysql with the force installation I mean with out the dependency check you will keep face the series of problems with various applications. It is advisable to go for ...


0

The issue is the folder permission. Check the folder and file permissions of the application folder.As well as verify the path too.


0

You can try a clean uninstall of all that is related to mysql. sudo apt-get purge mysql-community-server mysql-server And then reinstall the mysql-server. If that does not work, try to do a search for mysql using apt: apt-cache search mysql And try to install another version for mysql-server and mysql-client.


0

I had the same error message and the same emptyness in the log files. In my config-file (my.cnf) I had specified that I wanted to use myisam tables, by adding this line in the [mysqld]-section: default-table-type = myisam After upgrading mysql it seems this causes mysql not to start. I have changed this to: default-storage-engine = myisam and now ...


1

You are adding an unwanted c in libmysqlc++-dev. It should be libmysql++-dev. sudo aptitude show libmysql++-dev Package: libmysql++-dev State: not installed Version: 3.2.1+pristine-1 Priority: optional Section: universe/libdevel Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com> Architecture: i386 Uncompressed ...


0

The package is libmysql++-dev, without the c. If you get the same error when installing the above, then you'll need to change your archive mirror: Select one from here, making sure it's close to your location. Enter gksudo gedit /etc/apt/sources.list into the terminal Replace the current mirror with your newly-chosen one The package should then ...


4

There is no package named libmysqlc++-dev in Ubuntu. If you want the development files for the MySQL C++ library bindings install the package libmysql++-dev (without the c).


1

I would combine parts 1 and 2. MySql allows you to take encrypted backups as detailed here: mysqlbackup --backup-image=/backups/image.enc --encrypt --key-file=/meb/key --backup-dir=/var/tmp/backup backup-to-image The next bit would be to push the image up to a cloud service. This comes down to personal preference. If you like Dropbox, it has a ...


0

Step 1 : Download XAMPP for Linux 5.5.24 & 5.6.8 click here Download Step 2 : open terminal ( Ctrl+Alt+t ) cd Downloads sudo su chmod 755 xampp-linux-x64-1.8.3-1-installer.run ./xampp-linux-x64-1.8.3-1-installer.run Step 3 : follow the instructions Step 4.1 : Start Apache,MySQL /opt/lampp/lampp start Step 4.2 : stop Apache,MySQL ...


0

To install the latest Apache version, simly run these commands on Terminal: sudo apt-get update sudo apt-get install apache2 To use the PHP and MySQL versions you mentioned, you simply need to install them following this general rule: apt-get install <package name>=<version> But before doing that, I seriously do not understand why you need ...


1

You can't access mysql with user root without using a username, this is normal behavior of mysql. All you have is to provide the password using -p option mysql -u vindhya -p userPassword


1

At installalation mysql-server asks for a password, this is for the mysal root user,who is not identical to your systems root user. Mysql has its own users. Look in /etc/mysql/conf.d/debian.cnf for user debian-sys-maint user and pawword and connect with mysql -u debian-sys-maint -p It will ask for the password that is also in that file.


0

The password you entered is wrong , try typing your correct password or Follow the link so that your problem gets solved https://help.ubuntu.com/community/MysqlPasswordReset


0

You should have been able to set up a password while installing MySQL. Assuming you did, you should use the following syntax to log on to your server: mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1 If you get the same or similar error, try: mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1 --protocol=tcp


0

In searching around I came across a better script and decided to try it, and it works: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ ! "$(/usr/sbin/service mysql status)" =~ "start/running" ]] then echo "MySQL restarted" | mail -s "Email Subject" email@domain.com sudo service mysql start fi More info can be found here ...


2

Yes, in theory this is possible, as long as you make sure that neither service is running at the time of the copy/paste, and the new server is the same version as the old one. However, as you are well aware, it is not the recommended way.


0

Try doing a purge, then re-install. sudo apt-get remove --purge mysql-server sudo apt-get install mysql-server-5.6



Top 50 recent answers are included