Search Results

(2017-09-13) > update mysql.user set Password=PASSWORD('newpass') WHERE user='username'; > flush privileges;

(2006-09-07) Previously, in MySQL To create a user jsmith with password Secret15 and allow them to do anything with the database named accounts, connect to the database with mysql and issue the command: mysql> grant all on accounts.* to jsmith@localhost identi...

Comma Separated Values format for MySQL Data mysql> SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM response_answers;

(2023-05-02) The most common way to get a list of the MySQL databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command. $ mysql -u me -p [-h remotehost] mysql> show databases -> ; +--------------------+ | Datab...

(2017-06-21) SELECT User FROM mysql.user; More info: SELECT User, Host, Password FROM mysql.user;

To make mysql listen only on the localhost interface, add the following to each of the three sections in /etc/my.cnf bind-address = 127.0.0.1

(4 February 2013) Problem When doing an import, I get the error: ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes Solution Open a terminal and run this: $ mysql -u root -p mysql> set global net_buffer_length=1000000; mysql> se...

...assuming you are using the rpms that come with your distro, and you have actually installed the rpms. # chkconfig mysqld on # service mysqld start # mysqladmin password $YOUR-ADMIN-PASSWORD # mysql -u root -p mysql > select user(); > quit

Problem: An apache Tomcat application could not connect to the mysql database. The user was defined as username@localhost. The error displayed was: "#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server" Solution: Ensure that in /et...

(2023-05-02) You can use the CURRENT_USER and USER functions as follows: SELECT CURRENT_USER(); SELECT USER(); CURRENT_USER shows who you are authenticated as, while USER shows who you tried to authenticate as.