28 Replies
What are you trying to accomplish?
I resolved that issue already, thanks for noticing. But the problem is i cant login to admin. Could you check my config file? here:
/* Authentication type and info /
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Lang'] = '';
/ Bind to the localhost ipv4 address and tcp /
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['port'] = '3308';
/ User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
my username: root
my password: password what kind of error is this? ERROR 1045 (28000): Access denied for user 'adria'@'localhost' (using password: YES)
my password: password what kind of error is this? ERROR 1045 (28000): Access denied for user 'adria'@'localhost' (using password: YES)
That's a rights issue in mysql
You have to set up a user in mysql and then use that user and password in your config
Bro, my last choice is to reset the mysql or reinstall xampp. What do you recommend?
i cant access my database, but i can open it thru putting the aut type to 'config' which mean i can access it without using username and password
you can reset mysql's password and add new users as long as you have access to the machine it's running on
I'd recommend looking up instructions online for resetting mysql's root password in xampp and then follow other instructions on how to add a user for your application so you can use those credentials to connect to the db
what are you trying to do?
im really confused
Good news, problem solved! Im happy! This guys is a life saver!https://www.youtube.com/watch?v=mqBp9RLtPDs
REGex Software
YouTube
how to reset mysql root password in windows 11 | how to reset mysql...
how to reset mysql root password in windows 11 , how to change mysql root password
mysql root password reset in mysql workbench
Things discussed in video:
how to reset mysql root password
how to change mysql root password
mysql root password change in windows 11
reset mysql password
#mysql #mysql_workbench #database #windows
i was trying to login php admin
php admin?
database?
you mean, phpmyadmin?
in xampp?
yes
oh, the login is "do nothing" in localhost/phpmyadmin
who loves PHP?
you shouldnt change the configurations of it because then you will struggle to do things like creating users
i think php is not for beginners?
this has nothing to do with php
this is just mysql
oh yea im sorry haha
phpmyadmin is a mysql client
My professor told us to use php for capstone project. But i was into javascript so i dont have any idea about php but good thing theres AI
if you use xampp, all you need to do is to delete the trash in htdocs and put stuff there
oh ok, thank u
asking ai for help is like going to the town drunk and asking for his favorite lighter color
you may get a somewhat convincing answer or incomprehensible garbage
you never know
my biggest problem working with mysql is everytime I stop or exit the server i got sql errors when i come back
yea
lol
make a post with the errors
yea but good thing u guys like u is existing to help people like me
im stressing a lot working with my first project
Thanks for the second time!
i didnt do anything but you're welcome
i just appreciate your effort bro