MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
0
votes
0answers
13 views
How to update MySQL client on Ubuntu
I just manually updated MySQL server on my Ubuntu 12.04.2 server to 5.6 because of the new InnoDB full-text search feature. Via apt-get I only get MySQL 5.5.
However, the client was not updated with ...
0
votes
0answers
9 views
mysql workbench will not start
I have a really odd problem. I had a raspbian installation on a raspberry pi running mysql and mysql workbench. Everything was working fine, then I tried to import a backup db on to the pi using mysql ...
-1
votes
0answers
33 views
install phpmyadmin 4.0.3 centOS 6.3 or 6.4 minimal [closed]
I want to install phpmyadmin 4.0.3 on CentOS 6.3 or 6.4 minimal
I am a beginner. Can any one help me install it step by step?
-2
votes
1answer
29 views
How to combine Zabbix with MariaDB? [closed]
Ubuntu Server 13.04;
Zabbix actual version from source code;
MariaDB 5.5
Fistly I've download and unpack Zabbix source code.
After that:
./configure --enable-server --enable-agent --with-mysql ...
0
votes
0answers
19 views
VS2010 Program won't connect to MYSQL from local SQL Server Computer
my problem here is very weird compared to other that I found on this forum. The VB program is created with VS2010 from computer "A". It work perfectly. Connection to SQL Server and MYSQL DB. But when ...
-1
votes
0answers
11 views
403 forbidden error on AWS
through putty I have deleted whole site directory as follows. After logging in with my ec2 instance to putty as ec2-user I used
rm -r -f * command
then I tried to install it freshly so I followed ...
0
votes
0answers
13 views
dyld error DBI mysql on MacOS Mountain Lion
I try to use DBI mysql on my Mac mini but get this error. I found many solutions on the internet but cannot solve it. Help me please.
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
...
1
vote
1answer
33 views
Error installing mysql 5.5 FATAL ERROR: Could not find my_print_defaults
I installed Mysql 5.5 using Homebrew, specifically Homebrew versions - https://github.com/Homebrew/homebrew-versions. After the installation, I attempted to run the commands it suggests:
Set up ...
0
votes
1answer
19 views
Can LibreOffice Base directly use MySQL syntax?
From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
0answers
19 views
Error while creating new database
I would create new database on my server (I use free one on Biz.nf). In a window MySQL DBs I still have one place for it, but still i get error while creating it. When I had Joomla template I had DB ...
0
votes
3answers
28 views
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) [despite commenting out bind-address & skip-networking]
Okay, so disclaimer: I'm an absolute mysql noob. Gimme any other development type area and I'm fine.
So, I just started using Ubuntu 12.04 an setup mysql. Never really used localhost since we have a ...
0
votes
0answers
19 views
String comparison not working in databases, files… could the character set be an issue? [migrated]
I recently encountered a strange problem with strings:
I had 2 tables:
| AgentCodes | CREATE TABLE `AgentCodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`AgentName` varchar(32) CHARACTER SET utf8 ...
-3
votes
0answers
21 views
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in F:\xampp\htdocs\testing\foreign_key.php on line 19 [closed]
class db{
private $host, $username, $password, $database, $link, $sql;
function __construct($x, $y, $z, $a){
$this->host = $x;
$this->username = $y;
...
0
votes
1answer
13 views
Storage requirements for MySQL TEXT column
I have a MySQL table called errormsg2 using MyISAM storage engine with about a dozen columns.
Two of those columns I estimate account for most of the space used for each row, and they are of ...
1
vote
2answers
15 views
How to connect to MySQL on shared Host?
I am web developer and i just wonder Why i can't connect to mysql database on almost all my website with command line (all of theme use cpanel) and when i saw that port 3306 is closed !!
How could i ...
0
votes
0answers
8 views
MySQL db management through FreePBX
Is there an already prebuilt library for adding realtime DB management to an Asterisk Web-based GUI, like FreePBX ?
-1
votes
0answers
26 views
How can I install 'emma' ( mysql tool ) on CentOS. In Ubuntu it is as simple as “apt-get install emma”
I downloaded the emma from a Google result and then untar-ed it.
wget http://www.fastflo.de/files/emma/downloads/python_src/emma-0.6.tar.gz
tar -xvzf emma*
cd emma*
But I can't run ./configure. ...
0
votes
1answer
46 views
Curl Returns “Connection Refused” when trying to access localhost
I am running Xampp (Apache, Mysql and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following:
curl -v -i ...
2
votes
1answer
72 views
mysql how to fix Access denied for user 'root'@'localhost'
Before I screw up something, when login using $ mysql -u root -p , and show databases,
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql ...
0
votes
1answer
20 views
creation of accounts for each users in mysql / phpmyadmin
I am planning to create mysql accounts for each of my web devs and build their own databases. I need these devs to have accounts to access their own phpmyadmin where they can manipulate their own sets ...
0
votes
0answers
29 views
Specified port 3306 is already in use when installing MySQL 5.6
How can I solve the problem when I try to install MySQL 5.6 and it tells me that the specified port 3306 is already in use. I uninstall my previous MySQL which is version 5.1 already and I do not have ...
0
votes
0answers
14 views
How do I install an originally not installed Xampp service
When I originally installed Xampp I didn't install MySQL as I didn't need it. I do now, how can I install it without uninstalling Xampp??
-2
votes
0answers
23 views
Size of Sqlite DB with 75000 records [closed]
I need to have SQLite DB with 75000 record. The table may have 7 columns. Only text data will be available in the DB. What will be the estimate size of the SQLite DB? Can i implement these huge data ...
0
votes
0answers
14 views
Error resizing mysql command line client
I installed MySql 5.6 on Windows Vista (32Bit).
I am trying to resize the MySql commandline client window.
Right Click on top left-> Properties -> Increase Width and height of screen in Layout Tab
...
0
votes
1answer
21 views
Trouble installing MySQL [closed]
kirk$ sudo gem install mysql2 -v '0.3.11'
Building native extensions. This could take a while...
ERROR: Error installing mysql2:
ERROR: Failed to build gem native extension.
...
-1
votes
1answer
38 views
How to update a Powerpoint slide with an external database?
I have a database of 1000 users with their name, number, photos, addresses, and other fields, etc. (in RDBMS-like say mysql, PostgreSQL). But I want to implement this mostly in Excel.
So what I want ...
0
votes
0answers
37 views
Creating a form for editing multiple tables in a MySQL database
I'm writing a MySQL database, hosted on a Linux server (Ubuntu 12.04) and was intending to use OpenOffice Base on a client machine to act as a front end for data entry.
That's fine for editing a ...
0
votes
1answer
18 views
Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
...
0
votes
0answers
33 views
Mysql Server cannot start on Mac OS 10.8
I have installed MySQL server 5 through Macport on OS X v10.8.3 computer. Then followed the instruction on webpage http://2tbsp.com/content/install_and_configure_mysql_5_macports?page=1 to set it ...
0
votes
0answers
35 views
MySQL access denied after reboot due to named error?
Every two weeks or something my MySQL root pw is magically reset after reboot. I'm running a virtual server (Ubuntu 12.04) and it's running fine for approx. 2 weeks. Every two weeks (approx.) i'm ...
1
vote
2answers
25 views
MySQL cannot recognize variable on file option
I'm using MySQL 5.6 on Mac OS X 10.8 and trying to configure mysql to log genreral_log into a file. However, it always throws an error when I start it.
Here is the .my.cnf file looks like (located at ...
3
votes
1answer
62 views
Transfer Amazon S3 data to MySql Database [closed]
I have about 350000 files in my Amazon S3.
I need to transfer them to a MySql database running in my server..
Which is the best way to do this?
I saw this post which uses Pipeline, but Pipeline is ...
-2
votes
0answers
29 views
Average time for importing 750MB mysql database on WAMP [closed]
I am trying to import a database with 750MB of data size via the command mysql import.
It's been running for 45 minutes now.
Is this normal? How can I verify that it is running or see if it is ...
0
votes
1answer
43 views
Problems with mysql_upgrade
During restarting mysql I had come errors, one of them was
2013-05-16 12:48:06 56189 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
And I decided to try ...
1
vote
1answer
33 views
Elementary OS - Stop MySQL from starting automatically at boot
MySQL is started automatically each time I boot my ElementaryOS Luna, how can I disable this and have MySQL off by default?
I have verified that the mysql service is disabled at all runlevels using ...
0
votes
0answers
14 views
Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories) [duplicate]
I recently configured NDB-cluster with MySQL and MySQL just crashed ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tried re-installing ...
0
votes
0answers
26 views
Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)
I recently configured NDB-cluster with mysql and Mysql just crashed
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tried re-installing ...
2
votes
1answer
63 views
MySQL query fails instantly
I recently loaded a large (~5GB) database from an SQLdump into a local MySQL server database. Loaded fine after a couple of tries, and initially I could query without a problem, although queries took ...
1
vote
1answer
32 views
Connecting mysql via 127.0.0.1 instead of localhost
I connected mysql on Mac OS X using this command:
mysql -u root -p -h 127.0.0.1
After I logged in, I fired up this command:
select user();
and it showed:
root@localhost
and even wired, I ...
1
vote
1answer
61 views
Installation of latest MySql server
I have downloaded the MySql 5.6.11 win32 version. Facing problem in installing this downloaded version. I can't find any setup file.
I am new to this please help me to install MySql server on my ...
1
vote
1answer
40 views
mySQL outfile & permissions under Ubuntu Linux
I know there are already several postings on the stackexchange sites about Linux permissions, but I can't find the answer to my problem.
I'm working on my own laptop (no web server or anything) with ...
0
votes
1answer
97 views
How to access my database stored in PHPMyAdmin from different computers?
I am working on my Java application in Eclipse that connects to the database and makes some queries with the data. This database has been created and managed in PHPMyAdmin. The database is stored ...
0
votes
0answers
22 views
Allow MySQL access to domain users (Active Directory)
Configuration: Ubuntu Server 12.04.2 with MySQL connected to a Windows Domain with likewise-open5.
The idea is to allow MySQL access to domain users without adding every single one to MySQL users.
...
0
votes
0answers
26 views
PHPMyAdmin removes the primary key for MySQL table
First of all, I'm sorry for the ambiguity in this question. Because I don't know what the exact problem is, so I'm hoping somebody here faced the same issue and will be able to know what I'm doing ...
1
vote
1answer
20 views
Moving from one user to another in MySql
To login into mysql, in ubuntu we have a option from terminal like
shell# mysql -uxxx -pyyyy;
Now, I would be as "XXX" user in mysql. and terminal would be like
mysql>
Now, I want to ...
1
vote
1answer
31 views
Company Cloud Where I Can Assign Files To A User
I'm looking for a script/solution for my company. Basically a place to store our contracts/invoices for our clients online (so it will be hosted on our web servers), giving our clients access to our ...
0
votes
0answers
7 views
Why does MySQL detach from AMPPS control?
Sometimes while using AMPPS it looses control MySQL. The process is running, but AMPPS thinks it has quit. How is this happening, and how to I prevent it?
0
votes
1answer
53 views
xampp 1.8.1 on Windows 8 issues with PHP code using Notepad++
I am currently having a problem with xampp on windows 8. I installed xampp 1.8.1 and I didn't have any problems with the installation and I was able to configure Apache and MySQL just fine. But when I ...
2
votes
3answers
426 views
phpmyadmin symlinks error after ubuntu upgrade
After the upgrade of my ubuntu server to 13.04 my phpmyadmin is no longer reachable. the browser reports 500 (internal server error) and in the error.log it says:
PHP Fatal error: require_once(): ...
-1
votes
1answer
25 views
phpMyAdmin: Make foreign relation more readable [closed]
I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but ...
