search for: mysql_secure_installation

...tgreSQL sofar, but have now to install MySQL (and WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # service mysqld start # /usr/bin/mysqladmin -u root password 'xxxxx' # /usr/bin/mysql_secure_installation Then I've noticed that mysqld_safe process is listening at 0.0.0.0 and decided to change that - so that my WordPress installation only uses domain sockets (or unix pipes? not sure). So I've modified the /etc/my.cnf to: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user...

Hello CentOS users, for a Wordpress website I have installed mysql-server-5.1.69-1.el6_4.x86_64 and run /usr/bin/mysql_secure_installation on a CentOS 6.4 machine with mucho RAM (32 GB) and I wonder, what would be the best place for the mysqld parameters descibed at http://dev.mysql.com/doc/refman/5.1/en/server-parameters.html mysqld_safe --key_buffer_size=64M --table_open_cache=256 \ --sort_buffer_size=4M --read_buffer_si...

...pt I need to run which is interactive and I don't know how to deal with this. Basically this is the flow I have follow on the script at test environment and is the same I want to achieve in the Dockerfile without user interaction by just answering as you seen on the flow below: # /usr/bin/mysql_secure_installation Enter current password for root (enter for none): [ENTER] // because there is no password OK, successfully used password, moving on... Set root password? [Y/n] n ... skipping. Remove anonymous users? [Y/n] Y ... Success! Disallow root login remotely? [Y/n] n ....

...). One has to install mariadb-plugin-connect, python-mysqldb and alembic packages (alembic does not work when installed via pip). Additionally - since MariaDB by default does not have a root user password set and running mysql -u root requires sudo as well - you need to execute the following: sudo mysql_secure_installation sudo mysql_upgrade -p --force So far so good. I run into problems when running alembic when I get to the following change: e96a0b8071c_increase_pjsip_column_size.py mariadb fails this operation with error "Specified key was too long; max key length is 767 bytes" when it tries to increase...

Hello, I discovered today that CentOS 7 has replaced MySQL with MariaDB. Which is fine, it's seems really similar. And I was already aware that it was written by the original team that wrote mysql. It's cool that the mysql command still gets you in! This is the version I have: [root at web1:~] #mysql --version mysql Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline

...riadb-plugin-connect, python-mysqldb and alembic > packages (alembic does not work when installed via pip). > Additionally - since MariaDB by default does not have a root user password > set and running mysql -u root requires sudo as well - you need to execute > the following: > sudo mysql_secure_installation > sudo mysql_upgrade -p --force > > So far so good. I run into problems when running alembic when I get to the > following change: > https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_ > increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjs > CUjWDL5p09D...

On 5/10/2015 1:04 PM, Earl A Ramirez wrote: > Did a little Googling [0] and I saw that they recommend starting it as > follows: > > /etc/init.d/mysql start which is old school sysVinit style. my guess is, you'll need to fix up a systemd service description file, like /usr/lib/systemd/system/mariadb.service -- john r pierce, recycling bits in santa cruz