Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KathyWhitehead
- Order by date
-
No Root user for MySQL after creation
Thanks - you are a star. As I had to log in in safe mode, I couldn't use GRANT - BUT I was able to use SQL to Create a user 'root' with all the permissions (took a while) but now everything works. Couldn't have done it without your input.- KathyWhitehead
- Post #7
- Forum: MySQL
-
No Root user for MySQL after creation
Thanks for your help so far. I have got a little further with this I used the command: sudo dpkg-reconfigure mysql-server-5.0 This allowed me to set the root password. I can now get in to MySQL from webmin and log in to MYSQL as root. This however has not given me permissions to do...- KathyWhitehead
- Post #5
- Forum: MySQL
-
No Root user for MySQL after creation
I have tried to login to MYSQL via webmin and via the command line. If i try 'root' I can't get in at all. I logged in to MySQL in safe mode using the 'mysqld_safe --skip-grant-tables &' command, and ran the query SELECT user, PASSWORD from user. The only user that was returned from the...- KathyWhitehead
- Post #3
- Forum: MySQL
-
No Root user for MySQL after creation
We have recently installed MySQL 5.0.51 on Debian Linux. It seems something went wrong in the set up because there is no root user. I logged in in safe mode and the only user there is 'debian-sys-maint'. I am not prepared (at this stage) to change the password etc of this user until I can be...- KathyWhitehead
- Thread
- Replies: 6
- Forum: MySQL
