Hot answers tagged mysql
2
Connecting to MySQL using 127.0.0.1 requires the TCP/IP protocol.
The problem is that the mysql client tries to outsmart you by saying
If you specify 127.0.0.1 and do not tell me the protocol, I will use the socket and behave like a localhost connection.
If you specify 127.0.0.1 and tell me to use TCP/IP, THEN I will use a TCP/IP connection
In light of ...
2
So I have no idea what caused this, but it seems like the line
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
Was spot on - I rebooted my system and can now query again without failure. I wonder if this is related to the fact that after loading ...
2
Don't store these files in your database. I hope you are talking about storing a reference
to the files in database which is the preferred way to do it.
Also don't do 350k inserts , try and do larger bulk inserts. Check the MySQL Docs
Or store your newly created table as a .csv and LOAD DATA
EDIT
If I understand correctly the AWS Pipeline can generate a ...
1
The option log-error is a server option (mysqld).
It is recognized in /etc/my.cnf under the [mysqld] group.
That option does not exist for the mysql client program and would not be understood under the [mysql] group header.
Click Here to see all the options for the mysql client program.
The reason log-error works under the [mysqld_safe] group header? ...
1
Access denied for user 'root'@'localhost' (using password: YES)
It cant connect to your local mysql server as root from localhost. Have you tried https://dev.mysql.com/doc/refman/5.5/en/access-denied.html
Try renaming .my.cnf if you have one
mv /root/.my.cnf /root/.my.cnf.bak
and rerun the command.
1
I don't believe it is; as far as I can tell from the phpMyAdmin instances to which I have access, you'd have to modify the phpMyAdmin source so as to have the query used to generate this view include a JOIN on the table containing the data you want displayed. Theoretically possible, but difficult and not really advisable in practice.
1
For me the following solution solved the problem:
In my website conf file, I have the following section:
<IfModule mod_php5.c>
AddType application/x-httpd-php .php
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_admin_flag allow_url_fopen Off
...
1
PHPMyAdmin is a web interface to mysql server. So your data are already on a mysql server instance on your computer. You have two choices:
Keep the database on your computer and administrate it properly
Put it somewhere online to delegate management to experienced users.
If it is for a production environment, then I recommend you the second choice. If it ...
1
There's a huge installer banner on that page, you want the installer from https://dev.mysql.com/downloads/installer/5.6.html - the first one is a full, offline installer, the second one is an online version (downloads everything during the setup).
By the way, are you sure you don't want just to install XAMPP, which comes with Apache, PHP, MySQL, FileZilla ...
Only top voted, non community-wiki answers of a minimum length are eligible
