1

MySQL installed with predefined password

view story
linux-howto

http://stackoverflow.com – So I'm running crunchbang linux and installed mysql-server using the following terminal command: sudo apt-get install mysql-server Setup runs without problems, but when trying to access mysql I get "Error 1045 Access denied". The tutorial I used stated that during setup of mysql-server I'd be asked to set a password, but this step never happened. Edit: Completely removed everything related to mysql from my system (including configuration files), problem persists. When trying mysql -u root mysql the error also occurs, although according to the documentation this should grant me acces (HowTos)

dadebian's picture
Submitted by dadebian on 12/18/2012

Stories similar to MySQL installed with predefined password

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

mysql problems 35 weeks 6 days ago

All I want to do is run mysql and test very basic things out, but mysql is fighting me every step of the way...

I dont think ive ever changed any settings since ive installed it, I just want to run mysql and look around etc

Code: joe@joe-U46:/etc/init.d$ mysql ERROR 1045 (28000): Access denied for user 'joe'@'localhost' (using password: NO) I try:

Code: mysql -u root -p mysql I

I receive the following error when trying to connect to mySql through phpmyadin:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

Hello all,

I have installed mysql using instructions from: https://help.ubuntu.com/community/ApacheMySQLPHP

Quote:

Note: If you have already set a password for the mysql root, you will need to use: mysql -u root -p(Did you forget the mysql-root password?

I think yum is having problems installing MySQL 5.1 because there is already a pre-existing MySQL 5.5 installation.

I wanted to cleanly remove MySQL 5.5 (I had problems with 5.5 with PHP and Python).

I've been trying to figure out why I keep getting this error when I try to connect to the MySQL server with the following commands.

$~ mysql -u username -h SQLserver -p Enter password: ERROR 1045 (28000): Access denied for user 'username'@'myIP' (using password: YES)

I've done the following: Port is open in the firewall other wise I wouldn't get the error it'd just timeout. MySQL server not run

I finally got a Raspberry Pi for Christmas and decided to set it up as a home web server. I have nginx with php setup and working. I came to install mysql and ran sudo apt-get install mysql-server.

Installing MySQL complete? 50 weeks 3 days ago

How I can install mysql in ubuntu 12.04(gnome 3). So that I will have my mysql installation in /usr/bin/mysql

It's library and header files in /usr/lib/mysql and /usr/include/mysql respectively.

Last time I tried sudo apt-get install mysql-server mysql-client mysql-common The mysql has been installed in /usr/bin/mysql.