New answers tagged mysql
0
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? ...
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 ...
0
The mysql client tool does not recognize the log_error option, and you should not attempt to use it.
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.
0
Elementary OS is based on Ubuntu so I would have a look through the /etc/rc
directories and see if there is an entry in there which is starting mysql
The Ubuntu guide for this sort of thing suggests something along these lines:
rm /etc/rc*/*myscript
where 'myscript' is the service you want to stop starting at boot
0
I am doing the same thing and got similar errors. Then I realized my path was not exactly correct. Gave it the correct path all was well. If you are literally using '~/Downloads' for the path I expect this is not correct. More likely it's something like '~drew/Downloads'. You could also try using the full path to your downloads directory.
TD
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 ...
0
It's a quite unfortunate answer, but you cannot.
Regarding the use of ANSI escape sequences, MySQL only allows the following:
You can use the escape sequences “\b”, “\t”, “\n”, “\r”, “\”, and “\s” in option values to represent the backspace, tab, newline, carriage return, backslash, and space characters.
Regarding cmjdmiller's answer, grc only works ...
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 ...
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 ...
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 ...
0
You'll have to quit. But there are some interesting perspectives in this similar question here.
4
ProjectSend (formerly "Clients Oriented FTP"), a PHP/MySQL application, does exactly what you're looking for.
0
If your open_basedir contains /usr/share/php/php-gettext/ already (as in my case) and you can't get it to work with the previous answers then do:
sudo rm /usr/share/phpmyadmin/libraries/php-gettext/*
removes the symbolic links
sudo ln /usr/share/php/php-gettext/* /usr/share/phpmyadmin/libraries/php-gettext
creates hard links
This makes phpmyadmin work ...
0
http://wynnnetherland.com/journal/a-stylesheet-author-s-guide-to-terminal-colors
This is deffinatley a Terminal/Prompt Question...
This article explains a lot on the topic.
I cant help much more without knowning the prompt you are using though.
0
In the above solution, the file to be modified is located on:
sudo gedit /etc/apache2/conf.d/apache.conf
Do not forget to restart the server:
sudo /etc/init.d/apache2 restart
0
How to use Xampp right under Win 8.
http://www.youtube.com/watch?v=Fxo4_DX4ejU
And dont forget to install the PHP Microsoft C++ Runtime Package.
And start setup_xampp.bat with Admin rights.
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
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.
0
Can you check that you have installed these Visual C++ runtimes, both are required
[Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)][1]
[Microsoft Visual C++ 2008 Redistributable Package (x64)][2]
-1
grant all on *.* to root@'192.168.56.1'
0
You have an incomplete PostgreSQL install or uninstall. apt will try to finish any incomplete installs/uninstalls before performing the task you requested, and will fail if it can't finish the interrupted task.
You will observe that apt-get -f install also tries to do something with Pg. It's because you have an incomplete or damaged Pg install that apt is ...
Top 50 recent answers are included
