Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
18 views

Verifying the Current Version of PHPmyAdmin and Updating if Not

A question was asked on this forum concerning having the latest versions of MySQL, Apache, and PHPmyAdminn. In reviewing this question, I followed up on PHPmyAdmin to verify whether I had the latest ...
-1
votes
1answer
18 views

Where is save data base made in mysql-workbench?

I want know where are saved by default the data base made with mysql-workbench. I want know the directory.
0
votes
1answer
16 views

Trouble in configuring mysql in ubuntu

while trying to configure mysql in ubuntu i got the followig error I tried reconfiguring but it wont work PLease help me on this
0
votes
0answers
8 views

On connecting to MySQL via SSL getting ERROR 2026 (HY000): SSL connection error: protocol version mismatch

I am working with MySQL and generated the certificates to use with MySQL to enable SSL. Here are SSL configs: mysql> show variables like '%ssl%'; +---------------+----------------------------+ | ...
0
votes
0answers
5 views

Every few days the VPS maxes out all it's resources and has to be cold restarted. Methods to narrow down the reason?

CPU load, memory usage, apache usage, mysql usage peak at the same time to incredible values making even logging in via SSH impossible and the server has to be restarted from the hosting interface. ...
0
votes
0answers
15 views

How to shut down (or stop) Apache and My-SQL servers from my LAMP setup? [duplicate]

I just followed the fool proof instructions on how to set up LAMP server on Ubuntu (here: http://howtoubuntu.org/how-to-install-lamp-on-ubuntu). Now I need to know how to not have it running all the ...
0
votes
0answers
8 views

How to configure my LAMP server to POST form data to database

I have installed LAMP server on Ubuntu. I've got apache configured and running just fine. I think my problem is somewhere in the configuration of PHP or SQL.... as I have very little experience in ...
0
votes
0answers
11 views

ISPCONFIG Ubuntu 14.04 phpmyadmin 404 Not Found

After following this tutorial https://www.howtoforge.com/perfect-server-ubuntu-14.04-apache2-php-mysql-pureftpd-bind-dovecot-ispconfig-3-p4, and successfully completed when i try to acces phpmyadmin ...
0
votes
0answers
16 views

DOVECOT: Access denied

I am trying to set up a mail server following this tutorial: http://www.starbridge.org/spip/spip.php?article12#dovecot-sasl-lda-imap-et-sieve I cannot receive emails on my email client (thunderbird). ...
-1
votes
1answer
140 views

How to install ownCloud 8.0.0 in Ubuntu 14.04?

I am following this link to install ownCloud in Ubuntu 14.04 and faced following errors. PHP modules have been installed, but they are still listed as missing?Please ask your server administrator to ...
0
votes
1answer
51 views

mysql-server fails to install after previous failure (and start, and thus configure)

Ubuntu 14.10 64bit sudo apt-get purge mysql-server-5.5 mysql-common && sudo rm -r /etc/mysql Now that we are uninstalled sudo apt-get install mysql-server Reading package lists... Done ...
0
votes
0answers
19 views

Ubuntu 14.04 phpmyadmin : “Login without a password is forbidden” error

I searched lots of Questions and answers here and i applied the solution too. I edited config.inc.php and commented $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; too ,then I restarted apache server ...
0
votes
2answers
22 views

How to reset mysql root password without logging into mysql?

I want to reset mysql root password but I don't want to log into mysql and then reset the password just as follows, mysql -u root FLUSH PRIVILEGES; SET PASSWORD FOR root@'localhost' = ...
0
votes
1answer
84 views

MySQL not starting in Xampp

I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order): sudo chmod 755 /opt/lampp/etc/my.cnf sudo chmod -R ...
0
votes
2answers
23 views

Trying to enter mysql prompt

I have install MySql and now i am trying to get into the prompt of mysql with this command: mysql -host localhost -p but I am getting this error ERROR 2005 (HY000): Unknown MySQL server host ...
0
votes
3answers
67 views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
0
votes
0answers
21 views

Can't login in phpmyadmin in ubuntu 14.04

I can't login in phpmyadmin using my root password. Moreover, it is not showing any error message too. When I enter password, it redirects to ...
0
votes
0answers
27 views

Cannot reset mysql root password

I can't login to the localhost phpmyadmin neither to the mysql server as root (through the terminal). On both places I get the #1045 error. I followed this answer but the queries were affecting no ...
-1
votes
0answers
11 views

Unable to install mysql-server-5.6 on ubuntu 14.04 [duplicate]

when i install mysql server on Ubuntu 14.04 san@san-desktop:~$ sudo apt-get install mysql-server-5.6 Output: E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: ...
0
votes
1answer
28 views

mysql does not start automatically

I'd like mysql to start on boot but it does not, because I had removed rc.something (don't remember what was it) previously when I wanted it to not start automatically. Now in order to run it I need ...
-1
votes
0answers
12 views

createing a folder in phpmyadmin rootfolder got apache

I am new to ubuntu and recently i installed and working with it(13.04). i've installed phpmyadmin successfully but connected it with mysql . i want to create a folder. so that i can access it as ...
1
vote
0answers
39 views

Something wrong with my terminal

I am trying to run this command apt-get install mysql-server and it sets up the packages but when it reaches a point where a password input is needed, this is the screen i am getting I can't even ...
0
votes
1answer
26 views

MySQL Server keep shutting down

mysql server is keep shutting down, i am using DigitalOcean 512 MB Memory and 20GB Disk. I am running WordPress and iRedMail. Here are my Error Logs: Version: '5.5.38-0ubuntu0.14.04.1' socket: ...
0
votes
1answer
46 views

Linux Ubuntu Mysql issue

I am not sure if something is wrong with my mysql (runing on dedi server). I might have missconfiguared something, or using a wrong port to connect to, or if it's getting blocked. I'm quite new with ...
0
votes
0answers
41 views

Installing Drupal 8 on a LAMP stack… 404 not found, alternate installation instructions?

I installed a LAMP stack, and followed instructions on how to install Drupal 8, but the page is 404 ing, there is either a problem with the steps, or how I followed them, and I am open to alternate ...
1
vote
1answer
64 views

How to kill MySqlWorkBench process in Ubuntu?

I have installed Mysql Workbench on My machine (ubuntu 14.04 LTS) Lately this software is hanging alot. I want to kill the process I ran the command ps aux but I'm unable to find the Mysql ...
1
vote
0answers
84 views

Why are MariaDB versions different with same configurations?

So, last night I install a fresh copy of ubuntu 14.04 and followed some instructions for installing MariaDB as follows: > sudo apt-get install software-properties-common > sudo apt-key adv ...
0
votes
1answer
31 views

Ok, I have problem with code for adding values into mysql db, there is a posts (db table, java form created in Eclipse)

package sokic; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import ...
0
votes
1answer
74 views

Xampp MySQL and PhpMyamin error ubuntu 14.04

just installled latest xampp package on my localhost and on my terminal everything looks fine as shown below: **root@SKYBUNTU:/home/maze# /opt/lampp/lampp start Starting XAMPP for Linux 5.6.3-0... ...
0
votes
0answers
13 views

Query line working on widows does not work on mono

I migrated my program on Ubuntu 1.14.1 LTS Mono 1.7. MYSQL Localhost server version is 5.5.40 I have a method which works fine on Windows platform. I restore from backed up data in my hd format CSV ...
0
votes
0answers
6 views

where can I find mysql/ODBC library for gcc

I want to access a mysql database I have on my godaddy website from a C program. What GCC libraries should I download/install.
0
votes
1answer
54 views

Errors /var/cache/apt/archives/mysql-server-5.5_5.5.40-0ubuntu0.12.04.1_amd64.deb

After some messing around and uninstalling mariadb-server, I have problem installing mysql-server: root@serv:# apt-get install mysql-server-5.5 Reading package lists... Done Building dependency tree ...
0
votes
2answers
214 views

Wordpress can't upload files

I have installed LAMP stack and Wordpress on a local apache2 server using the tutorials here- ...
1
vote
1answer
116 views

How to deploy: Mezzanine + MySQL

So, here is a question: How to deploy Mezzanine, a Django CMS, locally with MySQL instead of default SQLite? What is the exact recipe?
0
votes
0answers
29 views

ls command not showing latest file

I just did a mysqldump on my Ubuntu EC2 server. If I browse the directory in Filezilla, I can see the dump file, but not when I run the ls command in terminal. Why is this happening?
0
votes
0answers
16 views

Having difficulties in installing mysql 5.6 on ubuntu 14.04 [duplicate]

I am new to Ubuntu. I have been able to install Ubuntu on Windows 7 using VBox virtual machine. I am facing difficulties regarding setting up of Mysql5.6 on my Ubuntu box. It gives me various ...
1
vote
3answers
154 views

How to fix dpkg error (1)

To be honest i'm not using Ubuntu but Debian (7.8), but as the commands are almost alike and this doesn't seem like an OS related problem to me, I figured I'd ask it on this glorious forum. I'm ...
0
votes
0answers
28 views

VirtualBox shared folder Apache and MySQL access

I've got some problems with Ubuntu 14.04 Desktop Guest on Virtualbox. I have shared folder from Win 8.1, in which I keep my www and mysql files. mysql and www-data users are added to vboxsf group: ...
0
votes
1answer
33 views

How do I fix amavis mysql warning “execute failed: Unknown column 'rseqnum'”

If you are using amavisd-new with a SQL server (Docs are located in /usr/share/doc/amavisd-new) you will see error messages similar to this: (!)WARN save_info_final: sql exec: err=1054, 42S22, ...
0
votes
1answer
48 views

Trying to setup a mail server on ubuntu 14.04

I'm trying to set up a mail server but get the following errors whilst trying to connect with thunderbird: Jan 7 03:11:59 Ubuntu-1404-trusty-64-minimal postfix/smtpd[6752]: lost connection after ...
1
vote
1answer
83 views

Mail Server Can't Receive Email But Can Send Email - Postfix, Dovecot, MySQL

I have server where I want to set up a mail server to let me receive and send email from my domain. I'm currently having a problem where while I am authorized to send email from the server, but ...
0
votes
0answers
111 views

Error in Processing Request Error code: 403 Error text: Forbidden

I have read the answer in Why do I always get a 403 error with phpMyAdmin? but it doesn't resolve my issue can anyone suggest me the quick solution. I am using ubuntu server version 14.04 My ...
1
vote
2answers
76 views

MySql server not recognizing correct password

I have installed MySql server on Ubuntu 14.04 LTS. I have prior experience to it too. But whenever I login, using mysql -u root -p and after entering password it says: ERROR 1045 (28000): Access ...
1
vote
1answer
67 views

Transfer a MYSQL database file from Windows (WAMP) to Ubuntu (LAMP)

My Windows computer is broken and I cannot do anything with it. I managed to get access to the hard drive and I am moving some websites I'm developing but I need the database that is located in: ...
0
votes
2answers
107 views

Not able to install, remove or update anything from software center

I'm having a bad time I guess. Everyday I'm facing new problems. My current problem is - I am not able to install, remove or update anything from software center. Also, sudo apt-get install -f is ...
1
vote
2answers
45 views

Is it possible to have to MYSQL servers running on one physical server?

I have a fast server with 8 CPU cores (and enough RAM). However this does speedup the MySQL-database, it does have its limits. So, I was thinking to setup a second Mysql-server on the same server. Is ...
0
votes
1answer
94 views

Using mysql in C programming [closed]

I installed ubuntu on a virtual machine.There,I installed mysql server(sudo apt-get install mysql-server) .This worked, because I could acces mysql-u root -p password. After that,I did : sudo apt-get ...
-1
votes
1answer
71 views

XAMPP Ubuntu - How would i import Employees Database into Mysql

I am new to linux and programming so any help is appreciated... I have downloaded the Employees sample database from: MySql Sample Database It has given me a .tar.bz2 file type, When i open ...
0
votes
0answers
22 views

mysql in lamp-server doesn't work [duplicate]

Just got myself a new VPS hosted at VPSDime and cannot get mysql to work (mention the host since I've never had the error before). I've had 2 fresh installs of both Ubuntu 14.04 LTS and 12.04 LTS and ...
0
votes
0answers
14 views

MySQL leaves empty logs?

I've been using MySQL to hold a database catalog of my music for another service I'm running on the server. I believe I set it up correctly, however, my logs /var/log directory gets filled with empty ...