Tag Info

New answers tagged

1

Does your mysql.user table have an entry for your database user for localhost host? If not, that is the reason for Permission denied error from MySQL.


3

SELECT statements will return number of rows into your shell variable. For DELETE statements just append a SELECT ROW_COUNT() after your mysql query, so it would be in your example like: RemoveID=`mysql -u root -proot -h 192.168.1.56 -e "delete from table where ID = '$1';select row_count()"` echo $RemoveID ROW_COUNT() 1


1

You could run a follow up query to check for the deleted ID in the script.


-1

I believe this should be added to your my.cnf: secure-auth = OFF


2

What version of the mysql module do you have installed? (check its Modulefile) Looks like the openstack modules depend on behavior of older versions of the mysql module, and declare that correctly in their dependencies - they seem to be happy only with 0.9.0. Assuming you're not using the mysql module elsewhere, try downgrading to that version.


0

Had to run reconfigure to get it back working again. This took some time for the program to finish itself up, it also errored and said it couldn't set mysql root password. But in the end it restarted mysql and everything came back online. dpkg-reconfigure mysql-server-5.5


0

You could run into inconsistent data if you introduce separate caches elsewhere than inside MySQL. And I think that is the reason in the first place why Galera has no query cache. The application should have its own cache with memcached, where required data would be stored.


1

Short answer: As of early 2014 there is no way to have the described behaviour in mysql. See relevant bug report and a page in dba.stackexchange where 3 different people comment that it's still not fixed in v5.5. Also as far as I can tell after a long googling there is no workaround worth using (see bellow why --sigint-ignore is not good). Andy's answer was ...


0

--skip-grant-tables means you're allowing any client to connect with unrestricted access to your databases. That points to your issue being a grant issue - you probably haven't granted the right permissions to the right user and/or IP.


1

You can resolve it by switching the mysql-libs package to mysql55w-libs. This needs to be done in one transaction to avoid it uninstalling the other dependencies: yum install yum-plugin-replace yum replace mysql-libs --replace-with mysql55w-libs yum install mysql55w mysql55w-server


0

This sort of is not a focused question, in that there is a ton left to interpretation. However, performance will always be resource based. There is a very small cost in overhead using the network(including request/response time) for the benefit of the ability to allocate more system resources to your application, not to mention isolating the disk I/O of each ...


0

I'm not sure this won't stray into the "too much opinion to be appropriate" realm really fast, but here goes. The major performance difference I can see it sacrificing the disk performance of a split model versus sacrificing the network performance of a unified model. Since (in my experience) you're much more likely to be disk-bound than network-bound, I'd ...


0

I encountered a similar problem. In my case, it was a missing PID file. So I had to manually kill the MySQL process and then restart it. The PID file was then created when I restarted MySQL. Here's a great post that may help you: http://linuxadministrator.pro/blog/?p=225


5

Percona is a MySQL fork/alternative and you have repos configured and enabled for it. You have 2 choices: 1) Remove anything related to Percona, including the repos and install MySQL. 2) Rmove anything related to MySQL and install Percona. Maybe clear the apt cache and do an apt-get update to try and fix the issue you have at your last command.


3

Yikes! I had no idea BGInfo could do this. Here's a report of success using MySQL. It looks pretty straightforward-- plain vanilla ODBC. You don't have to create any DSNs based on what I'm seeing-- the connection string is just in the BGI file. Your error message really makes it look like BGInfo is trying to use an SQL Server driver rather than the MySQL ...


2

This is Amazon's own user that is used by Amazon to perform updates, run backups and do other maintenance tasks. That said, Amazon's support should be able to advise you. In general, you don't need to (and should not) know the password.


1

This issue is related to the current user not having permissions to the file ./mysql/host.frm (/Applications/MAMP/db/mysql/mysql/host.frm) Presumably it is because it was installed by a different user, and all files are owned by that user and write permissions are only set up for the files' owner. In a typical MAMP installation the ownership is likely set ...


0

If you have this issue leave it alone and give it time. It takes quite a while for it to load the database and you will be able to use something to remove some of the database information in order to return it to a working status. You may also be able to dump the database and work on it that way.


1

My personal experience with windows implementations of PHP/MySQL have resulted in pain for me, my employees, and my customers. I have found many memory leaks and performance issues with PHP in 2008R2. MySQL uses a huge amount of memory in Windows. Security updates for exploits do not come as fast for windows if at all. In your situation I would seriously ...


0

Repairing the table won't fix it. The table is not corrupted in the first place. Running mysql_upgrade definitely fixes the problem.


1

I think you can check if your needed database working in simple manner in any shell $ mysql -uUSERNAME -pPASSWORD DATABASE -e exit and then check $? for exit code This command tries your specific credentials (USERNAME and PASSWORD) to connect to selected DATABASE and exit immediately. So, if connection is ok exitcode will be 0, and non-zero otherwise. ...


2

You can create the user mysql just before installation of the package. If you look at the preinst script of the package, this won't break anything: # creating mysql user if he isn't already there if ! getent passwd mysql >/dev/null; then # Adding system user: mysql. adduser \ --system \ --disabled-login \ --ingroup mysql \ ...


0

It could be due to the mysql database user table (use mysql; show tables;). If the bind to 0.0.0.0 don't work for you, try to give your user the host '%' in place of 'localhost' in that table. For example, try creating a user like: CREATE USER yourusername@'%' IDENTIFIED BY 'yourpassword' ant try to connect with that user.


0

The solution described in the link bellow should solve your problem http://www.debianhelp.co.uk/remotemysql.htm


2

Try to add bind-address = 0.0.0.0 to your [mysqld] section of your my.cnf and restart mysqld.


0

If you have no data in InnoDB, try deleting the InnoDB log files ib_logfile0 and ib_logfile1. The error log entry indicates that these somehow cause the problem.


0

Using Nagios to monitor MySQL service availability is OK but certainly not slow queries. I use a simple bash script which run every x seconds in crontab and scan processlist to capture queries running for more than 180 seconds. Hope it fits into your case aswell: #!/bin/bash Notify=me@company.com count=0 # capture all running queries echo ...


1

You could simply use a master-slave configuration for MySQL, simply specify the SSD machine as master, and replicate off of it. However, I strongly recommend using RDS unless you have a truly unique setup. RDS allows for provisioned IOPS and will take care of a lot of things you need to manually do for a mysql server.


0

Some general troubleshooting tips: Check if you have other/unknown/external connections to the database (for ex: netstat -tapn ) Check what queries are running and status of the server with with mysqladmin processlist and mysqladmin process status , this may lead to adding indexes to tables. Check slow query log (you've done this) Check the mysql error log ...


0

You have to let mysql bind to the specific interface IP , not to 127.0.0.1 so instead of bind-address = 127.0.0.1 you should rather write bind-address = 10.42.0.1


0

You need to backup your databases with -d switch, that way you will skip data backup and will only backup structure: mysqldump -d -u root -p password dbname > dumpfile.sql drag and drop is not applicable here.


1

You could the innodb_file_per_table (https://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table). Unfortunately you will get a file per table and not per DB (I don't know about an option for this in MySQL). With this you could link each table-file per symlink to different EBS-Volumes which are mounted to the instance. You ...


2

Have a plan regarding how to proceed if the server doesn't come up after the kernel upgrade Turn off the client-facing network connections (web server) so there are no more writes to the database Stop the database (shutting down services can be done in order by using the init scripts as suggested) Issue the reboot command


1

In my experience a maintenance reboot should start with the outer layer. So firstly the app server (apache then php-fpm or uwsgi etc.) followed by the database(s). If you are as paranoid as I am, run htop and netstat to ensure everything is closed. Then if you want to ensure that the hdd cache is flushed you may call sync. All that is left is a reboot. ...


3

You should configure your systems init scripts so that these steps occur in proper sequence automatically when your switch runlevels and that dependencies are satisfied (first shut down apache; then shut MySQL, etc). Really this is the purpose of the init script hierarchy that exists on Linux systems. This hierarchy is designed so that you may perform ...


7

This is a Red Hat Software Collection. It's meant to live outside the normal filesystem locations so as to not conflict with original system packages (in this case, the original MySQL 5.1). This means that, yes, you have to perform additional steps to use the software. See the documentation for complete details on how to use Software Collections.


0

I would centralize that information in a directory. The three services you mention support authentication using LDAP: There are several plugins to integrate WordPress with LDAP. The Enterprise version of MySQL can perform PAM authentication, indirectly providing LDAP integration. You don't mention what FTP server are you using, but it is highly probable ...


0

The most likely explanation would be that you are no longer logging in as a valid user through phpMyAdmin. From the phpMyAdmin main page, look to the right side; under "Database server" it should tell you what username you're connected as. Try connecting from the command line client with mysql -u root -p or whatever username you have instead of root. See if ...


0

Apparently you need to add double %% so that Postfix parses it to % when executing the query. Reference: http://www.postfix.org/mysql_table.5.html


0

It looks like sed is the easiest way in this context (after a clean install): sed -i "s/bind-address.*/bind-address = 0.0.0.0/" /etc/mysql/my.cnf


1

You have several valid options. You can go with an architecture where the requests are handle at the front by a load balancer (with nginx for example in a separate server or in one of the servers, or using a load balancer provided by your hosting company), the balancer redirects these requests to two or more "identical" servers that contain all the stack ...


2

I'd be looking at AWS. You can create autoscaling groups and you can use RDS to solve your database issues. MySQL replication isn't that hard to set up on your own: http://dev.mysql.com/doc/refman/5.6/en/replication.html Any modern load balancer will do health checks. E.g., hit your app and return a 200 if okay. If the LB gets a non-okay, it can remove ...


3

If it's mainly about ddos protection https://www.cloudflare.com/ might be worth checking out. Cloudflare is a basically a distributed/cloud-based CDN/reverse-proxy that also automatically provides ddos protection. This is perfect for static content, eventually a bit more challenging with dynamic content. Basic features are free of charge, advanced features ...


2

Your server was compromised (as per previous question and also confirmed somehow with the strange behaviour of binaries like tail or others that were replaced). So you have to do a clean re-install of everything; no commands can be trusted and they may not work properly as it seems to be happening. You should use a new server and install Linux and the rest ...


1

A few issues I see. You say you did this: sudo service mysql restart But are you logged in as root or a superuser? Also, This error makes 100% no sense: error:tail: invalid option -- n Try `tail --help' for more information. tail: invalid option -- n Try `tail --help' for more information. So are you trying to tail the MySQL log? And perhaps entered ...


0

You have to check for logs,check for mysql queries taking long time to execute. Use "top" or "htop" command to check what process make cpu usage 100%. Check for how many httpd instances are running Check when these website are hitting from url,what queries are executing in bacground(most of the time culprits queries are responsible). For ceentos use ...


1

Looks like a problem in the initialization scripts, temporarily you can try running mysqld or mysqld_safe to bypass them.


0

There's no row limit in a InnoDB table http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html , there's (huge) table size limit but you'll run into other constrains before hitting it. I suggest just in case to plan for an archiving strategy, where you move to another table/database old data.



Top 50 recent answers are included