Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
352 views

i want to install my sql client and server

i need to form network like "directory service" i am using ubuntu 13.10 client and 13.10 server i need to install "my sql server and client" Thanks and regards in advance
1
vote
1answer
99 views

Where is the database file from redmine after using the defaultinstallation?

After I installed redmine, I have a database called redmine and through phpmyadmin I can take a backup etc. , but I can't find the default location of it. Where is it placed? Any Idea? Does mysql ...
0
votes
2answers
2k views

mysqldbcopy: command not found

I am trying to run a script that requires usage of the mysqldbcopy tool. From reading the ubuntu manual, it appears that one just needs to install the mysql-utilities-1.3.5-1_all. When entering that ...
0
votes
1answer
142 views

Mysql died and won't start

I am working on Ubuntu 12.10 server with nginx, mysql and unicorn installed. There is something wrong with Mysql and has stopped working. Log message from /var/log/mysql/error.log Attempting ...
0
votes
1answer
284 views

HTML doesn't show php script on Uuntu 12.04 ( PHP5, Apache2, mysql) all are installed properly

But info.php in /var/www/ does show the info. Only PHP embedded in html doesn't show the script. please help me.. I have tried the previous askubuntu questions and didnot get anything useful so ...
3
votes
3answers
848 views

How to concate strings in a bash script to use in SQL-Statement? [closed]

I would like to do the following in a bash script: read some filenames out of an file with filenames set a variable input path concat 1. and 2. use 3. in sql-statement Here my code: #!/...
1
vote
1answer
1k views

mysql statement in bash shell script does not work / syntax error

hope someone can help me! I do not know what's wrong with this script (Bash / Ubuntu 12.04 / Mysql / XAMPP 1.8.3). Try to read an input file with a list of csv-filenames (449-R11, 449-R12 ..) in order ...
1
vote
2answers
7k views

Installing mysql 5.1 with Ubuntu 12.04

I have Ubuntu 12.04 installed, I need to install mysql 5.1 in that. Following steps I performed: Other things to be installed: Run this command to install alien and other necessary packages if not ...
15
votes
1answer
14k views

Start MySQL on Startup

I installed MySQL, and changed the configuration so the databases are stored on a separate hard drive. In the process MySQL has stopped starting up automatically. When I start the computer, I need to ...
2
votes
0answers
390 views

“package mysql-server is not installed” even when it is installed

I am trying to install a deb package running the command dpkg -i code/mydeb.deb it gives an error saying dpkg: dependency problems prevent configuration of openmrs: openmrs depends on mysql-...
0
votes
1answer
458 views

Can't run PHP script accessing my Mysql databse

I've created LAMP server in my ubuntu desktop. I've also made a sample database in Mysql having 6 columns. I can access it through the terminal. I've also created a php script for accessing the same. ...
0
votes
2answers
2k views

Mysql query browser or any Mysql gui tool in Ubuntu

I have installed Ubuntu 13.04 and now fully dependent on it. I have worked on mysql query browser in windows to run queries and procedures and programmers ,i could not find any other alternatives in ...
0
votes
1answer
226 views

mysql with ubuntu 13.10

I have a problem with mysql-server and client after a wrong configuration. I tried uninstalling both but I get an error when I uninstall mysql-server: start: Job failed to start invoke-rc.d: ...
0
votes
1answer
299 views

mysql server in ubuntu 13.04 not showing databases

i have installed Xampp(LAMPP) in Ubuntu 13.04 . i have secured the xampp phpmyadmin Mysql FTP. status showing ACTIVATED.now, i have installed mysql server.in terminal write mysql -u root -p and then ...
3
votes
3answers
11k views

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

I am getting this error while importing the database in mysql, and when I resubmit the same file than I am getting this error Error SQL query: -- -- Dumping data for table `adminnotification_inbox` ...
1
vote
1answer
2k views

MySQL won't start after removing bind-address

So, I am running mysql on an ubuntu server (command-line) VirtualBox, on a Windows 7 host. In the Virtual machine, I changed the /etc/mysql/my.cnf file by commenting out the line bind-address = 127.0....
0
votes
1answer
556 views

Unable to create a file in a certain location on Ubuntu

I'm trying to create a text file as below... mysql --host=localhost --user=root --password=11111 database1 << EOF SELECT * FROM table WHERE status = 1 INTO OUTFILE '/home/user/feeds/file.txt' ...
0
votes
1answer
96 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
1
vote
4answers
50k views

accessing MySQL using terminal in Ubuntu 13.04

accessing phpmyadmin db from terminal now in ubuntu 13.04 i firstly installed mysql server with sudo apt-get install mysql-server mysql server version 5.5 now in terminal i can check if it is working ...
3
votes
3answers
14k views

How to change mysql port number in ubuntu

How can I can change port number of mysql from 3306 to my choice of number (1023) in Ubuntu 13.10? I tried by editing the port number in file: /etc/mysql/my.cnf. But after this change mysql doesn't ...
0
votes
1answer
235 views

12.04.4 + MySQL 5.5 + Wordpress - MySQL Service Fails to Start

It appears that the issue is around the MySQL services starting as I receive the following in my /var/log/syslog when I attempt to restart the mysql service: Jan 17 08:19:38 blog kernel: [ 1704....
0
votes
1answer
118 views

cron not outputting correctly?

Please forgive my ignorance. I have searched, but perhaps I’m not sure really what to search for in order to answer my question myself, so I’m turning to this forum for a little guidance. I’ve ...
0
votes
1answer
672 views

How to set up Apache/MySql/Django environment for development

I've only been able to find tutorials to set up Apache/MySql/Django on servers, but I'd like to set up an environment on my machine for development. Does anyone have any good tutorials or suggestions? ...
0
votes
1answer
2k views

Installing libmysql on Ubuntu Server 12.04

I really need help installing the dependency of this, which is libmysql (here) I really have no idea how to install it. The author requires me to put it in a specific directory, but I have had no ...
0
votes
1answer
2k views

Can't Connect to MySQL via CLI or phpMyAdmin, but WordPress still connects fine

This is the first time I've had to reach out for a question -- I'm truly stumped. I have mysql up and running on a linux server (Ubuntu) and this morning tried to login to phpMyAdmin. I received an ...
1
vote
2answers
744 views

Unable to locate package libmysql++-dev

root@avidgamers:~/warcraft/aG-HostbotRU/ghost# apt-get install libmysql++-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
1
vote
2answers
3k views

How can I import multiple .sql files into MySQL?

In my folder, I have a lot of *.sql files... How via one command I can import them? For example; is something like this possible? mysql -u root -p db_development < *.sql If not, how can I ...
8
votes
1answer
6k views

Tora: No connection provider

I install tora on ubuntu 12.04. When I try to open, I'm unable to connect mysql database. Tora is not showing option for mysql.
4
votes
2answers
7k views

Is there a free MySQL manager with a visual query builder for Ubuntu?

I need a free MySQL manager with a visual query builder. I used to use EMS manager for MySQL in Windows but since I'm trying to be a Ubuntu user now, I need another tool with a visual query builder ...
1
vote
2answers
1k views

Ubuntu 13.10 apache keeps giving this error while accessing website

I have just installed Ubuntu 13.10. I followed this guide (most of it) to setup LAMP. Then I was getting this error about Could not reliably determine the server's fully qualified domain name ...
0
votes
2answers
1k views

How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?

I am setting up a daily backup of a MySQL 5.6.14 database using mysqldump on an Ubuntu 12.04 Precise server. I created the credentials file in the root home directory (.mylogin.cnf) according to the ...
1
vote
1answer
5k views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
2
votes
1answer
238 views

sendmail & MySQL

I had MySQL and PHP working good in the nginx server. For mailing purpose I installed sendmail. Now all I get is Your PHP installation appears to be missing the MySQL extension which is required by ...
0
votes
1answer
61 views

Mysql/php connection

I'm a newbie to ubuntu,and im trying to connect the mysqlworkbench(database) with php5.3 if (function_exists('mysql_connect')) { echo "Good<br />\n"; } else { echo "Bad.<br />\n"; } I'...
28
votes
3answers
256k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(...
1
vote
1answer
431 views

MySQL script does not stop, reboots mysql

I have installed ubuntu 13.10 desktop x64 on my laptop. After the installation I installed MySQL Server sudo apt-get install mysql-server mysql-client Installation wass successful but I noticed the ...
0
votes
1answer
840 views

Connect to mysql database on Ubuntu host from windows guest

I have Ubuntu 12.04 on my laptop and have a Windows 7 guest on (VMWare). I would like to connect to the mysql database on Ubuntu host from Windows guest.Kindly tell me how to do the same. I have tried ...
2
votes
1answer
531 views

what is the command to connect a database remotely from other PC

what is the command to connect a database remotely from other PC. I am running a application in a PC1(client) and storing some content of that application on a database. There is also one another PC2(...
1
vote
2answers
5k views

Cannot compile mysql code

I have the following code #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); exit(0); } ...
3
votes
2answers
379 views

How could I successfully log in under a non-existent user account?

I'm trying to setup ownCloud in a test lab. I somehow managed to create a 'owncloud' user (which is fine). The account has an empty password (I'm not sure how that happened), so I'm trying to set one: ...
3
votes
2answers
8k views

Updating variables in my.cnf

I set lower_case_table_names = 2 in /etc/my.cnf file. I also updated this variable in /etc/mysql/my.cnf file. After setting the variable I restarted mysql server, but still the value is 0, when I use ...
1
vote
0answers
22 views

Ubuntu Mysql suddenly locked me out [duplicate]

I'm experiencing a very weird problem here. I was using a mysql database for developing a rails app and everything was fine. Then I rebooted the computer (Ubuntu 13.10) and found myself locked out of ...
0
votes
1answer
41 views

autogenerate javascript from mysql

I have a site where I can upload images with some info (startdate, enddate, duration, url) I want to make a SlideShow that choose those pictures that is > $startdate && < $enddate. And I ...
1
vote
1answer
3k views

What makes mysql service autostart, while it's disabled in BootUp-manager?

The mysql service is not enabled in BootUp-manager, yet it is working after system starts. Is it awaken by another service? How to determine what causes that? EDIT Fix as instructed here.
0
votes
2answers
559 views

Is there a GUI for Apache, MySQL just like XAMPP for Windows?

I know how to install Apache, MySQL, PHP ..etc But I do not want Apache and MySQL to start at boot time. I also do not want to start them manually using the terminal. I am looking for a GUI program ...
14
votes
2answers
37k views

Mysql Job failed to start

I got an error while am up starting the mysql service. /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start Since the ...
2
votes
1answer
4k views

How to start Mysql server after installing from MySQL deb package?

I installed the mysql-5.6.15-debian6.0-i686.deb file on a MySQL site,and I installed it using the dpkg command but after that when I am writing: 1)sudo service mysql start The Answer is: mysql: ...
2
votes
0answers
432 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
0
votes
5answers
6k views

The best LAMP Stack with a GUI for Web Dev [closed]

I'm a spoilt windows user and always have used a WAMP stack with a GUI that allows me to start or stop apache and mysql services. I find it really hard switching to the LAMP command line and was ...
1
vote
2answers
16k views

install libmysqlclient-dev 5.6

I can't use the mysql ruby gem because I get this error: Incorrect MySQL client library version! This gem was compiled for 5.6.15 but the client library is 5.5.34. (RuntimeError) apt-get is ...