When.com Web Search

Search results

1. Results From The WOW.Com Content Network

2. How to connect to MySQL from the command line - Stack Overflow

   stackoverflow.com/questions/5131931

   Let me sample a few ways to connect to my sql. Option 1: mysql -u root -p : This with connect to user called root, -p flag will prompt for a password. Option 2: mysql -u root -p<PASSWORD> : Here you enter the password directly into the command and after execution the server connects quick without password prompt.

3. How to log in to MySQL and query the database from Linux...

   stackoverflow.com/questions/6200215

   Summary. Under the standard defaults for MySQL on recent versions of Ubuntu (at least 16.04-20.04, probably others), these are the commands to most easily connect to the mysql shell: MySQL root user: $ sudo mysql -u root. (enter your sudo password) Other MySQL user: $ mysql -u <username> -p.

4. How to allow remote connection to MySQL - Stack Overflow

   stackoverflow.com/questions/14779104

   19. Please follow the below mentioned steps inorder to set the wildcard remote access for MySQL User. (1) Open cmd. (2) navigate to path C:\Program Files\MySQL\MySQL Server 5.X\bin and run this command. mysql -u root -p.

5. logging - Log MySQL login attempts - Server Fault

   serverfault.com/questions/65255

   According to mysql official: As of MySQL 5.5.28, MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server plugin named audit_log. Only enterprising version has it. – Tiina

6. Access mysql remote database from command line

   stackoverflow.com/questions/15872543

   To apply the change you made, must restart mysql server using next command. sudo /etc/init.d/mysql restart Modify user root for lan acces ( run the query's bellow in remote server that you want to have access ) [email protected]:~$ mysql -u root -p .. CREATE USER 'root'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.*

7. MySQL: How to reset or change the MySQL root password?

   stackoverflow.com/questions/16556497

   Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal. Stop the MySQL Server: sudo /etc/init.d/mysql stop. (In some cases, if /var/run/mysqld doesn't exist, you have to create it at first: sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld. Start the mysqld configuration: sudo ...

8. How to connect from windows command prompt to mysql command line

   stackoverflow.com/questions/13752424

   Go to environment variables, 2. add the path of your MySQL Bin directory (suppose if it is "C:\MySQL\Bin", add this path to "PATH" in environment variable). 3. click ok ok and save all. 4. open command prompt and write 5. mysql -u root -p.. hit enter and it should work. it worked for me. – Manoj Kumar.

9. Mysql adding user for remote access - Stack Overflow

   stackoverflow.com/questions/16287559

   An alternative way is to use MySql Workbench. Go to Administration -> Users and privileges -> and change 'localhost' with '%' in 'Limit to Host Matching' (From host) attribute for users you wont to give remote access Or create new user ( Add account button ) with '%' on this attribute instead localhost.

10. How do I retrieve my MySQL username and password?

    stackoverflow.com/questions/4371

    204. Stop the MySQL process. Start the MySQL process with the --skip-grant-tables option. Start the MySQL console client with the -u root option. List all the users; SELECT * FROM mysql.user; Reset password; UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]'; But DO NOT FORGET to.

11. How to allow user to login to MySQL? - Stack Overflow

    stackoverflow.com/questions/2412607

    As a root mysql user, I executed the following: grant all on mydb.* to john identified by 'john1'; Then from shell, I tried to login via mysql -h localhost -u john -pjohn1; But when I do this, ...