Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 数据库权限问题

数据库权限问题

WBOY
Release： 2016-06-23 13:45:45
Original
1015 people have browsed it

是mysql 的数据库  服务器上有一个正式的网站 现在想弄一个测试的网站  因为数据库太大无法导入，所以进入服务器  把数据库复制了一份改了数据库名   把原来的网站也复制了一份，改了网站的配置文件，数据库的用户名和密码没变   现在浏览测试网站 发现可以查询 但是 更新的话会提示没有update的权限 请教一下 可能是什么原因


回复讨论(解决方案)

没有权限就设上权限

没有权限就设上权限

  复制的这个数据库 用户名和密码用的是总账号 不应该没有更新的权限才对  原来的数据库增删改查都可以的

既然是测试网站就把权限设置成最大777

修改用户信息 修改完提交   提示   update command  for  数据库用户名@localhost   denied

已找到原因  查到不是总账号，复制数据库以后属于匿名访问

Related labels：
数据库权限问题
source：php.cn
Previous article：问下怎么生成所有的不重复的数组 Next article：如何配置Php IDE的单步调试环境
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Laravel 8 - How to redirect /{editable_text} route to /{user} route I've been trying to create a redirect route to lead me to a user profile. The redirect rou...
From 2024-04-06 17:26:11
0
1
410
**Error type: Unable to iterate 'NoneType' object** I want to use ssh tunnel to access Mysql database. Unfortunately, the architecture of this...
From 2024-04-06 10:26:38
0
1
378
How to know when a Vue component is fully initialized? So, in my Vue component, I have an async created method and several variables with async w...
From 2024-04-05 14:20:24
0
1
1442
POST request works fine when using Postman but not when using React axios and Spring Boot backend From the react console I get the error "Unable to load resource: Server response stat...
From 2024-04-05 13:07:01
0
1
396
Releasing the X-axis after calling Chart.zoom(): a step-by-step guide I set the scroll strategy to setScrollStrategy(AxisScrollStrategies.progressive) and on th...
From 2024-04-04 23:40:56
0
1
1339
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template