Tag Info

New answers tagged

0

Try this command: sudo bash -c 'yum clean metadata && yum upgrade' After that install. Hope this will help you.


0

try $sudo yum update then if you correctly configure mirrors it will update packege db. try install mysql once more using $sudo yum install mysql-community-server if you don't have sudo installed then $su and install sudo #yum install sudo


0

I think my answer should really be a comment but here it goes. Just to be sure, did you follow the install instructions per the FAQ? Do you have an /opt/lampp directory after running with sudo? I don't think you will but it's worth a look. If you don't have the directory mentioned above then you can try running the installer with the --mode text option. ...


0

This is very much possible. This process I am going to explain is valid for a Ubuntu based system, but I hope there wouldn't be much differences for CentOS. Essentially, you will need to copy your mysql data files to the /var/lib/mysql/ folder. Mysql data files are distributes inside this folder as: . |-- debian-5.5.flag |-- ibdata1 |-- ib_logfile0 |-- ...


1

If you want to start mysql with a password provided you have to fetch the password in a variable first: MYSQLPASS=`cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2` Then you can start your mysql command with: mysql -U root -p ${MYSQLPASS} mydb -h friendserver


3

You have to be very careful how you pass passwords to command lines as, if you're not careful, you'll end up leaving it open to sniffing using tools such as ps. The safest way to do this would be to create a new config file and pass it to mysql using either the --defaults-file= or --defaults-extra-file= command line option. The difference between the two ...


0

See this post here: https://bugs.mysql.com/bug.php?id=1371 It looks like you need to REPAIR the table or drop and restore it.


0

Add user in mysql in this way: user@server1 This is the way MySQL expect to have user records for remove connection. And permit this user to manage database you use in php application. User is created in MySQL with command: CREATE USER 'user'@'server1' IDENTIFIED BY 'password'; And you grant privileges to the user with command like this: GRANT ALL ...


1

The connection parameter is a bit of a misnomer. It indicates the number of connections that have been made to the server since the server started. The one you might be interested in is Threads connected.


0

When Linux crashes, it crashes hard and rarely leaves behind a usable kernel core that gives you any help. For such a system, there's a few things you should do: Step up syslog output. Your system using rsyslogd which is even better. Ultimately you have a rule such as: *.* /var/log/debug Make sure the kernel module is enabled in rsyslogd. I've seen some ...


1

Adding #!/bin/bash did the thing, I just forgot to add that line. Can't really tell, why it does not work on the shell, but somehow it now works inside the script and inside the cronjob. Thanks for the comments.


2

You can use: help contents to retrieve a list of the top-level help categories. If you type: help 'Data Manipulation' Possible result will be: CALL DELETE DO DUAL HANDLER INSERT INSERT DELAYED INSERT SELECT JOIN LOAD DATA LOAD XML REPLACE SELECT UNION UPDATE More info you can find: Server-Side Help HELP Syntax


0

You're expecting systemd to work on a version of Fedora that pre-dates the full introduction of systemd into Fedora. That came in Fedora 15. Fedora 14 had but a "feature preview" that wasn't enabled straight out of the box. Out of the box, Fedora 14 ran upstart, so you'll have to make sure that you installed an upstart job definition for mysqld and start ...


0

grep is not the right tool for the job for loading XML. XML is a data structure that is tag oriented, so anything line oriented (like grep) will only work for a subset. Sometimes you get away with that, but you always create code that's brittle and prone to exploding messily, when someone 'upstream' generates perfectly valid XML which doesn't work because ...



Top 50 recent answers are included