Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
6 views

What do i write for the mysql data base and root uri

could someone please explain what i need to write on the red marked circles. im guessing that its asking for the database location and a mysql user and pass (which i haven't set up yet). Is mod cookie ...
0
votes
1answer
27 views

Ubuntu 14 installing phpmyadmin newbie question

Okay did a search first, and a whole bunch of folks are having problems with this one however my problem seems to be reasonably unique ... i.e. am doing something obviously wrong. Am getting the ...
0
votes
0answers
37 views

debconf-get-selections is not complete

I am researching preseeding/an unattended installation for MariaDB/MySQL. There are many resources online which are covering this procedure. My issue is the following, when I query for example: # ...
8
votes
7answers
7k views

phpmyadmin not working due to missing extensions

I am about to use phpmyadmin on Ubuntu 16.04. But it shows that the page is not working. the error log says error 500 PHP Fatal error: require_once(): Failed opening required ...
-1
votes
2answers
87 views

mysql not getting installed

I installed mysql with the following command sudo apt-get install mysql-server and it got installed correclty.then i uninstalled it by refering this link ...
0
votes
0answers
58 views

ERROR 1 (HY000): Can't create/write to file (Errcode: 13 - Permission denied)

I've been struggling for a couple of days with this now and have been trying to use this thread amongst other google searches to resolve it but can't seem to get it to work. When I run this SELECT ...
0
votes
0answers
27 views

Ubuntu server 14.04 read only filesystem, unable to recover important mysql data

Running Ubuntu server 14.04. A few days ago I ran a normal sudo apt-get and installed updates, the next morning my MySQL database that I used webmin to operate had broken down. I shut all processes ...
0
votes
1answer
28 views

MySql Installation problem in dual boot ubuntu 14.04

I am getting an E: Sub-process /usr/bin/dpkg returned an error code (1) error when installing mysql 5.6 in Ubuntu 14.04. I have tried to modified /var/lib/dpkg/info/mysql-server-5.6.postinst ...
0
votes
0answers
28 views

MYSQL (under ubuntu) Load Data Error

I am new to MYSQL and am trying to load data from a tab delimited file channels.txt into a MYSQL database tv_channels and am getting a "file not found" error. The file is in my home folder and is ...
0
votes
0answers
44 views

How to stop my from Server crashing: mpm_prefork:error and coredumps (used gbd)

I have a WP website on an Amazon AWS Ubuntu server and the website keeps crashing, I think it happens when having a lot of traffic. This is what I get the most of in /var/log/syslog file: Apr 5 ...
0
votes
0answers
37 views

Can not login to PhpMyAdmin

I installed xampp server in my Ubuntu machine. The phpmyadmin application was working well and fine on apache2 server, I tried changing the permission of /var folder one day, which I messed up, as a ...
0
votes
1answer
144 views

How to install MySQL 5.6.19?

When we do: # apt-get install mysql-server-5.6 we get version 5.6.28. We have tested and certified our app with 5.6.19, and we cant even create the schema in 5.6.28 due to changes made in ...
0
votes
0answers
23 views

automysqlbackup why no rotation in ubuntu package

why is neither in the man file of the ubuntu package of automysqlbackup nor in the conf-file in /etc/default/automysqlbackup the rotation option mentioned (meaning the possibility of deleting backups ...
0
votes
0answers
31 views

gtk and MySQL connection

can I use this code http://www.mono-project.com/docs/database-access/providers/mysql/ in gtk application ? else what I do for connect gtk application with Data Base in monodevelop ?
0
votes
0answers
9 views

MySQL fails to install, and is not accessible - dpkg returns error code 1

i need to install mysql-server on my machine , so i tried like this sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql A pastebin of my syslog can be found here. I get this ...
0
votes
2answers
63 views

Problem with C# MySQL Connection

Hello everybody i have a MySQL connection problem in C#. This is my problem in the picture. thanks for help me.
1
vote
2answers
209 views

Get a specific word using awk

I am coding a script to check mysql databases using bash script, I would like to check if the status of a table is not 'OK', will return the table name and do some more actions: check.log table1 ...
0
votes
1answer
45 views

Setting up multiple websites on a Linux server

I currently have an Ubuntu server, on which I have set up a little website for an old project, it's written in HTML/CSS/JS, and now I'm working on a new web app written in PHP and MySQL. I would ...
0
votes
0answers
38 views

Install bacula on 14.04 while running MariaDB

I tried to install bacula on a 14.04 installation but the installation routine always fails complaining about unmet dependencies. This is because I've installed MariaDB rather than MySQL. Is there any ...
0
votes
0answers
119 views

installing MYSQL

While trying to install MYSQL I get the following screen and it gets stuck. sudo apt-get install mysql-server [sudo] password for jishnu: Reading package lists... Done Building dependency tree ...
0
votes
0answers
38 views

Apt Upgrade not working

Hi I get the following error when I try to run apt-get upgrade sudo apt-get upgrade Reading package lists... Done Building dependency tree Reading ...
5
votes
1answer
249 views

Why does mariadb keep dying? How do I stop it?

I am running MariaDB 10.0.23-0 on Ubuntu 15.10 as a LAMP server. Running sudo /etc/init.d/mysql start results in: Job for mariadb.service failed because a timeout was exceeded. See "systemctl status ...
3
votes
1answer
596 views

MySQL 5.5 Update to MySQL 5.7

I searched a tutorial for dummies, about how to Update my MySQL 5.5 Server to MySQL 5.7 I'm Using ubuntu 14.04. I've already tried the tutorials on the MySQL Website. How can I upgrade my server?
0
votes
1answer
45 views

mysql access from netbeans 8.1 is very slow

I have the following installed on my laptop: Ubuntu 14.04 MySQL 5.5 Netbeans 8.1 Connecting to MYSQL databases from "Services" menu of Netbeans takes unusually long, upto 1 min or more. The ...
0
votes
1answer
131 views

APT - Error in installing mysql-server in Ubuntu 15.10

I'm trying to install mysql-server. I followed the steps discussed here: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#apt-repo-fresh-install, but when I try to install it I get this error: ...
0
votes
0answers
15 views

ubuntu 15.10 mysqld fails to start on restart

I am using 15.10 and mysqld fails to start up when I start the OS. I have to do this little patch to start it. sudo dpkg-reconfigure mysql-server-5.6 What configuration information am I missing. ...
1
vote
1answer
35 views

Mysql won't work

I am a newbie to Ubuntu and to everything Linux. Ever since I mistakenly formatted my window 8.1 laptop with Ubuntu 14.04 I have been having migraine headaches, trying to resolve the problem and the ...
-2
votes
1answer
196 views

Why the PHPMyAdmin stopped working after I upgrade PHP to version 7.0.4 on my machine running on 64-bit Ubuntu 14.04 LTS?

I'm using a machine that runs on 64-bit Ubuntu 14.04 LTS. Today, I upgraded from PHP 5.5.32 to PHP 7.0.4. After I made an upgrade my Apahce HTTP Server and PHPMyAdmin stopped working. I made ...
1
vote
0answers
125 views

MySQL Server 5.6 fails to install on Ubuntu Wily

I have Ubuntu 15.10 (wily) and am trying to update MySQL to the latest version. When I run aptitude safe-upgrade, it fails like so: Errors were encountered while processing: mysql-server-5.6 ...
0
votes
0answers
46 views

Cannot migrate to MariaDB

I try to "drop-in" migrate to MariaDB from MySQL: sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo apt-get install mariadb-server ...
1
vote
1answer
48 views

MySQL out of memory

I recently upgraded my VPS from 1 GB RAM to 2 GB because MYSQL kept crashing due to low memory. The server has been running fine for 3 weeks until now. The following is logged to /var/log/syslog ...
0
votes
1answer
23 views

Is it safe to move boot partition and increase the / (root) space?

I have dual boot machine (Windows 10 + Ubuntu 14.04) and disk status as above. I want to insert a very large data in MySQL db which >100G. For this, I think I have to increase my / partition using ...
0
votes
0answers
24 views

MySQL Server shuts down after start

When I start the server, irrelevant if it is mysqld or mysqld_safe, it will suht down after a second, giving me 2 warnings like [Time] [PID] Can't create test file ...
0
votes
1answer
103 views

MySQL installation fails and root password cannot be set

I am trying to install mysql server on ubuntu 14.0.4. When I ran sudo apt-get install mysql-server php5-mysql I got a message to set root password. When I did not set a password, it kept asking for ...
1
vote
0answers
96 views

Start Ampps, with root permissions, once desktop loads

Been hacking my way through getting Ampps to work on Ubuntu. Ampps will be used to use host a local Web app for my families business, and I need Ampps to start when Ubuntu starts, always. I figure I ...
0
votes
1answer
64 views

Does MSSQL interfere with MySQL on LAMP SERVER?

I'm currently working on a project that requires me to connect remotely to a MSSQL database on a different server. After some research and crawling of this site and google I think one of the ...
0
votes
2answers
203 views

take output from the mysql and stored into excel

i have database under that one table. for eg test_table. in that name age sex edu job timein doj yyy 33 m bsc comp 22/3/13 12:32:44 3/2/11 xxx 22 f mca soft ...
1
vote
1answer
134 views

mysql-workbench: Error log Permission denied

I recently installed mysql-workbench by installing first apt-config.deb from mysql website and then install the actuall mysql with sudo apt-get install mysql-workbenh (I used sudo for almost ...
-1
votes
1answer
29 views

Installing mysql server with postgresql

I'm using backbox 4.4 which it was built-in with postgresql. Yesterday i think about "can i installing mysql database along side postgresql database ? ", i want to learn database connection but i so ...
1
vote
2answers
60 views

How to properly install mysql on Ubuntu 14.04

I tried installing MySQL on my machine (sudo apt-get install mysql-server ) but after installation I cannot get it to run. When I enter mysql or mysql -u root command I receive the error ERROR 2002 ...
0
votes
0answers
40 views

Can't connect to MySQL

I have an issue that is driving me crazy. I have a php script to connect to a MySQL db and retrieve data. But I get an odd error: ERROR 1042 (HY000): Can't get hostname for your address I've ...
0
votes
0answers
39 views

mysqli_query no return

I've been trying to create a simple login script with php and mysql. I'm able to connect to the database and enter data into it, but I can't use SELECT to get data from the DB. This is my register ...
0
votes
1answer
131 views

mysql process stopping install as cannot kill

I am trying to install mariadb but install exits as fail as Mysql is running and it cannot stop. MySql is not installed but there is a process running which I cannot kill root@sonic-ubuntu ~ # ps ...
0
votes
0answers
51 views

MySQL compile error make-install

So I am attempting to compile MySQL from source for a project, Iv'e been following the steps and have already done cmake and make, created the mysql user and group, however when I attempt to make ...
0
votes
0answers
15 views

errors on cam survey

I am getting the following error: Failed to load resource: net::ERR_FAILED chrome-extension://fmfcbgogabcbclcofgocippekhfcmgfj/cast_sender.js Failed to load resource: net::ERR_FAILED ...
0
votes
1answer
74 views

Problem with Java and JavaScript

So tomorrow I'll be doing some labs for MySQL certification, and since in my country I can't get class training I had to choose Training On Demand (TOD) which is a good way to learn (You have recorded ...
0
votes
0answers
119 views

How to automate MySQL-Server without prompts in bash?

I would like to know how to automate the MySQL-Server installation through bash script on a Ubuntu 14.04 x64 LTS server using apt. I use a server on digitalocean and tried many solutions but none of ...
0
votes
0answers
67 views

Unhandled exception can't connect to mysql server on '127.0.0.1' (111) (code 2003)

I am new to Ubuntu using version 14.04 64-bit. I have successfully installed xampp and all services are running correctly. However I have installed mysql workbench and then I get the error; Unhandled ...
0
votes
0answers
26 views

Configuring Ubuntu for hosting Podcast

I want to be able to host podcasts. I have been trying to set up a MySQL server and even ordered some books but I'm not sure if it's the right system for what I want. I have no problem with audio ...
0
votes
1answer
22 views

I just installed xampp on ubuntu 14.04, mysql is not starting in control panel

I just installed xampp on ubuntu. When I am starting xampp using sudo /opt/lampp/xampp start, I am getting: XAMPP: Starting Apache...already running. XAMPP: Starting MySQL...ok. XAMPP: Starting ...